[/PACKAGE BODY blk_contacts IS

PROCEDURE NAME(event varchar2) IS

 BEGIN
 	
 	if event IN ('KEY-NEXT-ITEM','KEY-DOWN') then
 		init;
 		go_item('tbl_Contact.Contact_address');
 		set_item_property('button_bar.psave',enabled,property_true);
 	elsif
 		event IN ('KEY-UP','KEY-PREV-ITEM') then
 		go_item('tbl_Contact.Contact_title');
 	end if;
 
 END NAME;
 
PROCEDURE PCODE(event varchar2) IS
		
	var number(5);
	alr_dup number(5);
	
	BEGIN
		If event IN ('KEY-NEXT-ITEM','KEY-DOWN') then
			if :tbl_contact.contact_pcode is not null then
				select count(contact_pcode) into var 
				from ihelp.tbl_contact 
				where contact_pcode=:tbl_contact.contact_pcode
				and contact_code<>:tbl_contact.contact_code;
				if 	var>0 then
					show_window('win_dup');
					go_block('vew_dup');
					 set_block_property('vew_dup',default_where,'upper(ltrim(rtrim(contact_pcode)))='||upper(ltrim(rtrim(''''||:tbl_contact.contact_pcode| |''''))));
					execute_query;
					go_item('vew_dup.NB');
				else
					go_item('tbl_Contact.Contact_title');
				end if;
				else
					go_item('tbl_Contact.Contact_title');
				end if;
				
			elsif event IN ('KEY-PREV-ITEM','KEY-UP') then
				go_item('tbl_contact.active');
			end if;
		
	END PCODE;
	
END BLK_CONTACTS;--end package]

[/if ASCII('BUFFER') <> '13' then
	Message ('Press Enter Key to Proceed');
	Message ('Press Enter Key to Proceed');
	raise form_trigger_failure;
else
	NEXT_ITEM;
	end if;

to_char(to_date(receipt_detail_month||' '||receipt_detail_year,'Month rrrr'),'Mon rrrr') receipt_month,

to_char(to_date(''''||receipt_detail_month||' '||receipt_detail_year||'''','Month rrrr'),'Mon rrrr') receipt_month,

to_char(to_date(''''||receipt_detail_month||' '||receipt_detail_year||'''','Month rrrr'),'Mon rrrr') receipt_month

I tried
to_char(to_date(''||receipt_detail_month||' '||receipt_detail_year||'','Month rrrr'),'Mon rrrr') receipt_month,

SQL> select distinct receipt_detail_month
  2  from
  3  tbl_receipt_detail;

RECEIPT_D
---------
April
August
December
February
January
July
June
March
May
November
October

RECEIPT_D
---------
September
Term 1
Term 2


15 rows selected.

... WHERE receipt_detail_month not in ('Term 1', 'Term 2')

select col1, col2, ...
from your_table
where upper(purpose_name) <> case when :block.category_amount < 100 then 'WATER PUMP'
                                  else 'a value that does not exist'
                             end

 Name                            Null?    Type
 ------------------------------- -------- ----
 PURPOSE_CODE                             NUMBER(5)
 PURPOSE_NAME                             VARCHAR2(45)

if :tbl_category_detail.category_amount < 100 then
set_item_property (:block.item_name,show_lov,lov_2)