APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_INVESTOR_PAYOUT_SUMMARY_B

Line 258: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

254: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
255: PMTSCH.class = 'INV' AND
256: exists (
257: SELECT '1'
258: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
259: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
260: pay.lsm_id = LSM.ID
261: );
262:

Line 283: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

279: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
280: PMTSCH.class = 'INV' AND
281: exists (
282: SELECT '1'
283: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
284: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
285: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
286: -- pay.lsm_id = TLD.TLD_ID );
287: pay.TLD_ID = TLD.TLD_ID );

Line 996: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

992: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
993: PMTSCH.class = 'INV' AND
994: NOT EXISTS (
995: SELECT '1'
996: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
997: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
998: pay.investor_agreement_id = p_inv_agr_id AND
999: pay.investor_line_id = p_inv_agr_line_id AND
1000: pay.TLD_ID = TLD.TLD_ID) AND

Line 1032: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay

1028: PMTSCH.class = 'INV' AND
1029: PMTSCH.customer_trx_id = TLD.customer_trx_id AND -- cklee 06/25/08
1030: NOT EXISTS (
1031: SELECT '1'
1032: FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
1033: WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
1034: pay.investor_agreement_id = p_inv_agr_id AND
1035: pay.investor_line_id = p_inv_agr_line_id AND
1036: pay.TLD_ID = TLD.TLD_ID);

Line 2140: INSERT INTO okl_investor_payout_summary_b

2136: -- Populate PK from sequence
2137: ------------------------------
2138: l_idh_id := NULL;
2139: l_idh_id := get_seq_id;
2140: INSERT INTO okl_investor_payout_summary_b
2141: ( ID,
2142: OBJECT_VERSION_NUMBER,
2143: CREATED_BY,
2144: CREATION_DATE,