APPS.LNS_SUBMIT_FOR_APPROVAL_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 803: ar_payment_schedules pmt_sch, lns_Loan_Lines lines

799: CURSOR Csr_Loan_Amounts(p_loan_id IN NUMBER) IS
800: SELECT
801: nvl(sum(pmt_sch.AMOUNT_DUE_REMAINING),0) invoice_balance_amount, nvl(sum(lines.requested_amount),0) requested_amount
802: FROM
803: ar_payment_schedules pmt_sch, lns_Loan_Lines lines
804: WHERE
805: nvl(lines.installment_number, 1) = pmt_sch.terms_sequence_number
806: and pmt_sch.customer_trx_id = lines.reference_id
807: and lines.loan_Id = p_loan_id