APPS.LNS_FUNDING_PUB dependencies on AP_INVOICES_ALL

Line 3937: from ap_invoices_all

3933:
3934: -- get invoice_id from AP
3935: CURSOR get_invoice_cur(P_INVOICE_NUM VARCHAR2, P_PARTY_ID number) IS
3936: select invoice_id
3937: from ap_invoices_all
3938: where invoice_num = P_INVOICE_NUM and
3939: party_id = P_PARTY_ID;
3940:
3941: -- get projects details from LNS_DISTRIBUTIONS

Line 5573: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation

5569: (select count(1) from LNS_DISB_LINES
5570: where DISB_HEADER_ID = P_DISB_HEADER_ID and (STATUS is not null and STATUS = 'FULLY_FUNDED'))
5571: from dual;
5572:
5573: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation
5574: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5575: select nvl(sum(inv.amount_paid), 0)
5576: from LNS_DISB_LINES lines,
5577: LNS_DISB_HEADERS head,

Line 5578: ap_invoices_all inv,

5574: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5575: select nvl(sum(inv.amount_paid), 0)
5576: from LNS_DISB_LINES lines,
5577: LNS_DISB_HEADERS head,
5578: ap_invoices_all inv,
5579: lns_loan_headers_all loan
5580: where head.LOAN_ID = P_LOAN_ID and
5581: head.loan_id = loan.loan_id and
5582: --nvl(loan.current_phase, 'TERM') = nvl(head.phase, 'OPEN') and

Line 5627: from ap_invoices_all

5623:
5624: -- get invoice payment amount
5625: CURSOR inv_paid_amount_cur(P_INVOICE_ID number) IS
5626: select INVOICE_AMOUNT, AMOUNT_PAID
5627: from ap_invoices_all
5628: where invoice_id = P_INVOICE_ID;
5629:
5630: -- get min payment date - fix for bug 6906841
5631: CURSOR payments_date_cur(P_INVOICE_ID number) IS

Line 9292: ap_invoices_all inv

9288: inv.INVOICE_NUM,
9289: inv.cancelled_date
9290: from LNS_DISB_LINES lines,
9291: LNS_DISB_HEADERS head,
9292: ap_invoices_all inv
9293: where head.loan_id = P_LOAN_ID and
9294: head.DISB_HEADER_ID = lines.DISB_HEADER_ID and
9295: lines.status is not null and
9296: lines.status <> 'CANCELLED' and