APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on OKL_INVESTOR_PAYOUT_SUMMARY_B

Line 102: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY

98: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
99: AND RAA.APPLICATION_TYPE = 'CASH'
100: AND RAA.STATUS = 'APP'
101: AND RAA.applied_customer_trx_id = arl.customer_trx_id
102: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
103: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
104: AND PAY.TLD_ID = ARL.TLD_ID
105: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
106: BEGIN

Line 132: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY

128: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
129: AND RAA.APPLICATION_TYPE = 'CASH'
130: AND RAA.STATUS = 'APP'
131: AND RAA.applied_customer_trx_id = arl.customer_trx_id
132: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
133: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
134: AND PAY.TLD_ID = ARL.TLD_ID
135: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
136: BEGIN

Line 789: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY

785: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
786: AND RAA.APPLICATION_TYPE = 'CASH'
787: AND RAA.STATUS = 'APP'
788: AND RAA.applied_customer_trx_id = arl.customer_trx_id
789: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
790: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
791: AND PAY.TLD_ID = ARL.TLD_ID
792: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
793:

Line 1099: INSERT INTO okl_investor_payout_summary_b

1095: ------------------------------
1096: -- Populate PK from sequence
1097: ------------------------------
1098: l_idh_id := get_seq_id;
1099: INSERT INTO okl_investor_payout_summary_b
1100: ( ID,
1101: OBJECT_VERSION_NUMBER,
1102: CREATED_BY,
1103: CREATION_DATE,