APPS.OKL_CREATE_ADJST_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 119: ar_payment_schedules_all aps

115: FROM okl_bpd_leasing_payment_trx_v
116: WHERE payment_schedule_id = cp_psl_id; */ -- Bug 6358836
117: select distinct ractrl.interface_line_attribute6
118: from ra_customer_trx_lines_all ractrl,
119: ar_payment_schedules_all aps
120: where aps.customer_trx_id = ractrl.customer_trx_id
121: and ractrl.line_type = 'LINE'
122: and aps.payment_schedule_id = cp_psl_id;
123:

Line 504: AR_PAYMENT_SCHEDULES_ALL APS

500: OKL_AM_UTIL_PVT.get_chr_currency(RACTRL.KHR_ID) CURRENCY_CODE,
501: RACTRL.til_id_details TIL_ID,
502: RACTRL.TLD_ID TLD_ID
503: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
504: AR_PAYMENT_SCHEDULES_ALL APS
505: WHERE APS.PAYMENT_SCHEDULE_ID = cp_psl_id
506: AND RACTRL.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
507: AND RACTRL.amount_due_remaining > 0;
508:

Line 549: FROM ar_payment_schedules_all

545:
546: -- Code added by varao for bug #4728481 - START
547: CURSOR get_psl_context IS
548: SELECT org_id
549: FROM ar_payment_schedules_all
550: WHERE payment_schedule_id = p_psl_id;
551: -- Code added by varao for bug #4728481 - END
552:
553: --Bug 6316320 dpsingh start