APPS.LNS_FUNDING_PUB dependencies on AP_INVOICES_ALL

Line 3759: from ap_invoices_all

3755:
3756: -- get invoice_id from AP
3757: CURSOR get_invoice_cur(P_INVOICE_NUM VARCHAR2, P_PARTY_ID number) IS
3758: select invoice_id
3759: from ap_invoices_all
3760: where invoice_num = P_INVOICE_NUM and
3761: party_id = P_PARTY_ID;
3762:
3763: BEGIN

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

5269: (select count(1) from LNS_DISB_LINES
5270: where DISB_HEADER_ID = P_DISB_HEADER_ID and (STATUS is not null and STATUS = 'FULLY_FUNDED'))
5271: from dual;
5272:
5273: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation
5274: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5275: select nvl(sum(inv.amount_paid), 0)
5276: from LNS_DISB_LINES lines,
5277: LNS_DISB_HEADERS head,

Line 5278: ap_invoices_all inv

5274: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5275: select nvl(sum(inv.amount_paid), 0)
5276: from LNS_DISB_LINES lines,
5277: LNS_DISB_HEADERS head,
5278: ap_invoices_all inv
5279: where head.LOAN_ID = P_LOAN_ID and
5280: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and
5281: lines.invoice_id is not null and
5282: lines.invoice_id = inv.invoice_id;

Line 5323: select INVOICE_AMOUNT, AMOUNT_PAID from ap_invoices_all where invoice_id = P_INVOICE_ID;

5319: );
5320:
5321: -- get invoice payment amount
5322: CURSOR inv_paid_amount_cur(P_INVOICE_ID number) IS
5323: select INVOICE_AMOUNT, AMOUNT_PAID from ap_invoices_all where invoice_id = P_INVOICE_ID;
5324:
5325: BEGIN
5326: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' ');
5327: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');