[Home] [Help]
129: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
130: AND RAA.APPLICATION_TYPE = 'CASH'
131: AND RAA.STATUS = 'APP'
132: AND RAA.applied_customer_trx_id = arl.customer_trx_id
133: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
134: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
135: AND PAY.TLD_ID = ARL.TLD_ID
136: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
137: */
144: ra_customer_trx_lines_all ractrl
145: WHERE tld.ID = ractrl.interface_line_attribute14
146: and raa.applied_customer_trx_id=cp_customer_trx_id
147: and raa.applied_customer_trx_id = ractrl.customer_trx_id
148: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY WHERE
149: PAY.INVESTOR_AGREEMENT_ID IS NULL AND PAY.TLD_ID = TLD.ID AND
150: PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
151: BEGIN
152: OPEN l_receipt_amount_csr(p_customer_trx_id);
173: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
174: AND RAA.APPLICATION_TYPE = 'CASH'
175: AND RAA.STATUS = 'APP'
176: AND RAA.applied_customer_trx_id = arl.customer_trx_id
177: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
178: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
179: AND PAY.TLD_ID = ARL.TLD_ID
180: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
181: BEGIN
830: WHERE RAA.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
831: AND RAA.APPLICATION_TYPE = 'CASH'
832: AND RAA.STATUS = 'APP'
833: AND RAA.applied_customer_trx_id = arl.customer_trx_id
834: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY
835: WHERE PAY.INVESTOR_AGREEMENT_ID IS NULL
836: AND PAY.TLD_ID = ARL.TLD_ID
837: AND PAY.RECEIVABLE_APPLICATION_ID = RAA.RECEIVABLE_APPLICATION_ID);
838:
1143: -- Populate PK from sequence
1144: ------------------------------
1145: l_idh_id := get_seq_id;
1146: --Bug# 11935977: Added org_id to insert statement
1147: INSERT INTO okl_investor_payout_summary_b
1148: ( ID,
1149: OBJECT_VERSION_NUMBER,
1150: CREATED_BY,
1151: CREATION_DATE,