APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_INVOICE_PAYMENTS

Line 2011: FROM ap_invoice_payments

2007: l_flag varchar2(1) := 'N';
2008:
2009: CURSOR payment_cursor IS
2010: SELECT 'Y'
2011: FROM ap_invoice_payments
2012: WHERE invoice_id = P_invoice_id
2013: AND nvl(discount_taken,0) <> 0;
2014:
2015: BEGIN

Line 2050: FROM ap_invoice_payments p,

2046: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
2047:
2048: CURSOR payment_cursor IS
2049: SELECT 'Y', p.org_id
2050: FROM ap_invoice_payments p,
2051: ap_checks c,
2052: ap_system_parameters SP
2053: WHERE p.invoice_id = P_invoice_id
2054: AND p.org_id = sp.org_id

Line 2109: | ap_invoice_payments

2105: | FUNCTION - get_payments_exist_flag
2106: |
2107: | DESCRIPTION
2108: | returns 'Y' if an invoice has corresponding records in
2109: | ap_invoice_payments
2110: |
2111: | KNOWN ISSUES:
2112: |
2113: | NOTES:

Line 2127: FROM ap_invoice_payments

2123: l_flag varchar2(1) := 'N';
2124:
2125: CURSOR payments_exist_cursor IS
2126: SELECT 'Y'
2127: FROM ap_invoice_payments
2128: WHERE invoice_id = P_invoice_id;
2129:
2130: BEGIN
2131: OPEN payments_exist_cursor;

Line 2427: from ap_invoice_payments aip

2423: (nvl(p_discount_dist_method, 'EXPENSE') <> 'SYSTEM')))) THEN
2424:
2425: select count(*)
2426: into l_count_pmt_posted
2427: from ap_invoice_payments aip
2428: where aip.posted_flag = 'Y'
2429: and aip.invoice_id = p_invoice_id;
2430:
2431: select count(*)

Line 2436: from ap_invoice_payments aip

2432: into l_count_pmt_hist_posted
2433: from ap_payment_history aph
2434: where aph.posted_flag = 'Y'
2435: and aph.check_id in (select check_id
2436: from ap_invoice_payments aip
2437: where aip.invoice_id = p_invoice_id);
2438:
2439: END IF;
2440: