FROM_DT                                  DATE
 TO_DT                                    DATE
 REF_NO                                   VARCHAR2(20)

01-JAN-05 31-DEC-05 SVC/TS/1235
01-MAR-06 30-JUN-06 SVC/TS/4444

01JAN05 TO 31DEC05
01MAR06 TO 30JUN06

01JAN06 TO 28FEB08
01JAN07 TO 31DEC08

Declare
	cursor c1 is select	from_dt,to_dt
	from scrap_mst;
dt1 date;
dt2 date;
Begin
	open c1;
	loop
	fetch c1 into dt1,dt2;
	if :scrap.mst.to_dt between c1.from_dt and c1.to_dt then
	show_common_message('Already exist ......');
	Else
	null;
	End if;
	exit when c1%notfound;
	

	end loop;
	close c1;
End;

:scrap.mst.to_dt 

Declare
	cursor c1 is select	from_dt,to_dt
	from scrap_mst;
dt1 date;
dt2 date;
Begin
	open c1;
	loop
	fetch c1 into dt1,dt2;
	if :scrap_mst.to_dt between dt1 and dt2 
	or :scrap_mst.from_dt between dt1 and dt2 then
--	or :scrap_mst.from_dt between dt1 and dt2 then
	show_common_message('Already exist ......');
	raise form_trigger_failure;
	Else
	null;
	End if;
	exit when c1%notfound;
	

	end loop;
	close c1;
End;