APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 7096: FROM okl_bpd_leasing_payment_trx_v blp

7092: p_khr_id IN NUMBER
7093: )
7094: IS
7095: SELECT SUM (blp.amount_due_remaining)
7096: FROM okl_bpd_leasing_payment_trx_v blp
7097: WHERE blp.contract_id = p_khr_id;
7098:
7099: -- Cursor to get the lines with amount due and payment schedule id for the balances
7100: CURSOR k_bal_lns_csr (

Line 7111: FROM okl_bpd_leasing_payment_trx_v oblp,

7107: oblp.payment_schedule_id schedule_id,
7108: oblp.receivables_invoice_number ar_invoice_number,
7109: otil.ID til_id,
7110: -999 tld_id
7111: FROM okl_bpd_leasing_payment_trx_v oblp,
7112: okl_txl_ar_inv_lns_v otil,
7113: okl_strm_type_v osty
7114: WHERE oblp.contract_id = p_khr_id
7115: AND oblp.receivables_invoice_id = otil.receivables_invoice_id

Line 7126: FROM okl_bpd_leasing_payment_trx_v oblp,

7122: oblp.payment_schedule_id schedule_id,
7123: oblp.receivables_invoice_number ar_invoice_number,
7124: otai.til_id_details til_id,
7125: otai.ID tld_id
7126: FROM okl_bpd_leasing_payment_trx_v oblp,
7127: okl_txd_ar_ln_dtls_v otai,
7128: okl_strm_type_v osty
7129: WHERE oblp.contract_id = p_khr_id
7130: AND oblp.receivables_invoice_id = otai.receivables_invoice_id