Pymt_txn.status in ('C','R') and 
TRUNC (pymt_txn.value_date)  < TRUNC (SYSDATE - 65)

TABLE NAME		PYMT_TXN
		
Pymt_txn_id	number 	Primary Key
user_id	number 	
value_date	date	
status	varchar2(1)	P'  Process , 'C' Closed,'R' Rejected
last_modified_date	date	
		
		
		
TABLE NAME		TXN_DTL
		
DTL_TXN_ID	Number	Primary Key
pymt_txn_id	number	Foreign Key from PYMT_TXN table
last_modified_date	date	
benefeciary_1	varchar2(35)	
benefeciary_2	varchar2(35)	
.......		
...........		
		
		
TABLE NAME		PYMT_APPROV
		
pymy_Apprv_id	number	Primary Key
pymt_txn_id	number	Foreign Key from PYMT_TXN table
approval_1	varchar2(35)	
approval_2	varchar2(35)	
approval_date	date	
		
		
		
TABLE NAME		Signature_Details
		
signature_detail_id	number 	Primary Key
signature_event_id	number 	foreignKey from Signature_event Table
pymt_txn_ID	NUMBER	Foreign Key from PYMT_TXN table
dtl_text	VARCHAR2 (64 Byte)	
dtl_digest_clob_data	CLOB	

DELETE FROM A WHERE <CRITERIA> RETURNING COL_A INTO TEMP_A;
DELETE FROM B WHERE COL_B IN (SELECT COL_A FROM TEMP_A) RETURNING COL_B INTO TEMP_B;
DELETE FROM C WHERE COL_C IN (SELECT COL_B FROM TEMP_B) RETURNING COL_C INTO TEMP_C;
DELETE FROM D WHERE COL_D IN (SELECT COL_B FROM TEMP_B) RETURNING COL_D INTO TEMP_D;

DELETE FROM D WHERE COL_D IN (SELECT COL_B FROM B THE COL_A IN (SELECT COL_A FROM A WHERE <CRITERIA>));
DELETE FROM C WHERE COL_C IN (SELECT COL_B FROM B THE COL_A IN (SELECT COL_A FROM A WHERE <CRITERIA>));
DELETE FROM B WHERE COL_B IN (SELECT COL_A FROM A WHERE <CRITERIA>);
DELETE FROM A WHERE <CRITERIA>;