APPS.OKL_CREATE_ADJST_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 805: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,

801: RACTRL.STREAM_TYPE STREAM_NAME,
802: OKL_AM_UTIL_PVT.get_chr_currency(RACTRL.KHR_ID) CURRENCY_CODE,
803: RACTRL.til_id_details TIL_ID,
804: RACTRL.TLD_ID TLD_ID
805: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
806: AR_PAYMENT_SCHEDULES_ALL APS
807: WHERE APS.PAYMENT_SCHEDULE_ID = cp_psl_id
808: AND RACTRL.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
809: AND RACTRL.amount_due_remaining > 0;

Line 815: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,

811: --Bug 6727171 End
812:
813: CURSOR c_pmnt_schedule_summary(cp_psl_id IN NUMBER) IS
814: SELECT SUM(RACTRL.AMOUNT_DUE_REMAINING) AMOUNT_DUE_REMAINING
815: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
816: AR_PAYMENT_SCHEDULES_ALL APS
817: WHERE APS.PAYMENT_SCHEDULE_ID = cp_psl_id
818: AND RACTRL.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
819: AND RACTRL.amount_due_remaining > 0;