APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_RECEIPTS_DELETE_T

Line 4633: select CASH_RECEIPT_ID from FII_AR_RECEIPTS_DELETE_T

4629: )
4630: select RECEIVABLE_APPLICATION_ID, PAYMENT_SCHEDULE_ID, CASH_RECEIPT_ID
4631: from fii_ar_receipts_f
4632: where CASH_RECEIPT_ID in (
4633: select CASH_RECEIPT_ID from FII_AR_RECEIPTS_DELETE_T
4634: where CREATION_DATE <= g_sysdate_time
4635: )
4636: ;
4637:

Line 9484: delete from FII_AR_RECEIPTS_DELETE_T

9480: last_updated_by = g_fii_user_id
9481: WHERE log_item = 'AR_LAST_UPDATE_DATE';
9482: END IF;
9483:
9484: delete from FII_AR_RECEIPTS_DELETE_T
9485: where CREATION_DATE <= g_sysdate_time;
9486:
9487: END IF;
9488:

Line 9524: insert into FII_AR_RECEIPTS_DELETE_T (

9520: BEGIN
9521: l_key := p_event.GetEventKey();
9522: -- l_pos := instr(l_key, '_');
9523: -- l_id := substr(l_key, 1, l_pos - 1);
9524: insert into FII_AR_RECEIPTS_DELETE_T (
9525: EVENT_KEY,
9526: CASH_RECEIPT_ID,
9527: CREATION_DATE,
9528: CREATED_BY,