APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_INVESTOR_PAYOUT_SUMMARY_B

Line 273: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

269: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
270: PMTSCH.class = 'INV' AND
271: exists (
272: SELECT '1'
273: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
274: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
275: pay.lsm_id = LSM.ID
276: );
277:

Line 298: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

294: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
295: PMTSCH.class = 'INV' AND
296: exists (
297: SELECT '1'
298: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
299: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
300: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
301: -- pay.lsm_id = TLD.TLD_ID );
302: pay.TLD_ID = TLD.TLD_ID );

Line 1011: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

1007: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
1008: PMTSCH.class = 'INV' AND
1009: NOT EXISTS (
1010: SELECT '1'
1011: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
1012: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
1013: pay.investor_agreement_id = p_inv_agr_id AND
1014: pay.investor_line_id = p_inv_agr_line_id AND
1015: pay.TLD_ID = TLD.TLD_ID) AND

Line 1047: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

1043: PMTSCH.class = 'INV' AND
1044: PMTSCH.customer_trx_id = TLD.customer_trx_id AND -- cklee 06/25/08
1045: NOT EXISTS (
1046: SELECT '1'
1047: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
1048: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
1049: pay.investor_agreement_id = p_inv_agr_id AND
1050: pay.investor_line_id = p_inv_agr_line_id AND
1051: pay.TLD_ID = TLD.TLD_ID);

Line 1090: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

1086: AND arapp.receivable_application_id = ad.source_id
1087: AND ad.source_table = 'RA'
1088: AND NOT EXISTS
1089: (SELECT '1'
1090: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
1091: WHERE pay.receivable_application_id = ARAPP.receivable_application_id
1092: AND pay.investor_agreement_id = p_inv_agr_id
1093: AND pay.investor_line_id = p_inv_agr_line_id
1094: AND pay.TLD_ID = TLD.TLD_ID

Line 2228: INSERT INTO okl_investor_payout_summary_b

2224: -- Populate PK from sequence
2225: ------------------------------
2226: l_idh_id := NULL;
2227: l_idh_id := get_seq_id;
2228: INSERT INTO okl_investor_payout_summary_b
2229: ( ID,
2230: OBJECT_VERSION_NUMBER,
2231: CREATED_BY,
2232: CREATION_DATE,