APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1939: FROM ap_invoice_payments

1935: l_flag varchar2(1) := 'N';
1936:
1937: CURSOR payment_cursor IS
1938: SELECT 'Y'
1939: FROM ap_invoice_payments
1940: WHERE invoice_id = P_invoice_id
1941: AND nvl(discount_taken,0) <> 0;
1942:
1943: BEGIN

Line 1978: FROM ap_invoice_payments p,

1974: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
1975:
1976: CURSOR payment_cursor IS
1977: SELECT 'Y', p.org_id
1978: FROM ap_invoice_payments p,
1979: ap_checks c,
1980: ap_system_parameters SP
1981: WHERE p.invoice_id = P_invoice_id
1982: AND p.org_id = sp.org_id

Line 2037: | ap_invoice_payments

2033: | FUNCTION - get_payments_exist_flag
2034: |
2035: | DESCRIPTION
2036: | returns 'Y' if an invoice has corresponding records in
2037: | ap_invoice_payments
2038: |
2039: | KNOWN ISSUES:
2040: |
2041: | NOTES:

Line 2055: FROM ap_invoice_payments

2051: l_flag varchar2(1) := 'N';
2052:
2053: CURSOR payments_exist_cursor IS
2054: SELECT 'Y'
2055: FROM ap_invoice_payments
2056: WHERE invoice_id = P_invoice_id;
2057:
2058: BEGIN
2059: OPEN payments_exist_cursor;

Line 2355: from ap_invoice_payments aip

2351: (nvl(p_discount_dist_method, 'EXPENSE') <> 'SYSTEM')))) THEN
2352:
2353: select count(*)
2354: into l_count_pmt_posted
2355: from ap_invoice_payments aip
2356: where aip.posted_flag = 'Y'
2357: and aip.invoice_id = p_invoice_id;
2358:
2359: select count(*)

Line 2364: from ap_invoice_payments aip

2360: into l_count_pmt_hist_posted
2361: from ap_payment_history aph
2362: where aph.posted_flag = 'Y'
2363: and aph.check_id in (select check_id
2364: from ap_invoice_payments aip
2365: where aip.invoice_id = p_invoice_id);
2366:
2367: END IF;
2368: