[Home] [Help]
499: RACTRL.STREAM_TYPE STREAM_NAME,
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;