APPS.OKL_CREATE_ADJST_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 84: ar_payment_schedules_all ps,

80: ,ln.customer_trx_line_id
81: FROM okl_trx_ar_adjsts_v a,
82: okl_txl_adjsts_lns_v b,
83: ra_customer_trx_lines_all ln,
84: ar_payment_schedules_all ps,
85: okc_k_headers_b khr,
86: okc_k_lines_v kle,
87: okl_strm_type_v sty
88: WHERE a.id = b.adj_id

Line 104: FROM AR_PAYMENT_SCHEDULES_ALL APS,

100: ORDER BY ln.customer_trx_id, b.PSL_ID;
101:
102: CURSOR c_is_consolidated_invoice(cp_psl_id IN NUMBER) IS
103: SELECT 'Y'
104: FROM AR_PAYMENT_SCHEDULES_ALL APS,
105: OKL_CNSLD_AR_STRMS_B CAS
106: WHERE APS.CUSTOMER_TRX_ID = CAS.RECEIVABLES_INVOICE_ID
107: AND APS.PAYMENT_SCHEDULE_ID = cp_psl_id;
108:

Line 356: ar_payment_schedules_all aps

352: FROM okl_bpd_leasing_payment_trx_v
353: WHERE payment_schedule_id = cp_psl_id; */ -- Bug 6358836
354: select distinct ractrl.interface_line_attribute6
355: from ra_customer_trx_lines_all ractrl,
356: ar_payment_schedules_all aps
357: where aps.customer_trx_id = ractrl.customer_trx_id
358: and ractrl.line_type = 'LINE'
359: and aps.payment_schedule_id = cp_psl_id;
360:

Line 806: AR_PAYMENT_SCHEDULES_ALL APS

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;
810:

Line 816: AR_PAYMENT_SCHEDULES_ALL APS

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;
820:

Line 862: FROM ar_payment_schedules_all

858:
859: -- Code added by varao for bug #4728481 - START
860: CURSOR get_psl_context IS
861: SELECT org_id
862: FROM ar_payment_schedules_all
863: WHERE payment_schedule_id = p_psl_id;
864: -- Code added by varao for bug #4728481 - END
865:
866: --Bug 6316320 dpsingh start