DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 2591: FROM AR_PAYMENT_SCHEDULES_ALL PS,

2587:
2588: --Bug# 7456516 start
2589: CURSOR c_last_invoice_date(p_khr_id IN NUMBER) IS
2590: SELECT INVOICE_DATE FROM( SELECT MAX(HD.DATE_CONSOLIDATED) INVOICE_DATE
2591: FROM AR_PAYMENT_SCHEDULES_ALL PS,
2592: OKL_CNSLD_AR_STRMS_B ST,
2593: OKL_CNSLD_AR_LINES_B LN,
2594: OKL_CNSLD_AR_HDRS_B HD,
2595: OKC_K_HEADERS_B CN

Line 2608: ar_payment_schedules_all ps,

2604: UNION
2605: SELECT max(ractrx.trx_date) INVOICE_DATE
2606: FROM ra_customer_trx_all ractrx,
2607: ra_customer_trx_lines_all ractrl,
2608: ar_payment_schedules_all ps,
2609: okc_k_headers_b chr
2610: WHERE chr.id = p_khr_id
2611: AND chr.contract_number = ractrl.interface_line_attribute6
2612: AND ractrx.customer_trx_id = ractrl.customer_trx_id