APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 169: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

165: RETURN VARCHAR2 IS
166: invoice_posting_flag VARCHAR2(1);
167: distribution_posting_flag VARCHAR2(1);
168: l_cash_basis_flag VARCHAR2(1);
169: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
170:
171:
172: CURSOR posting_cursor IS
173: SELECT cash_posted_flag

Line 310: ap_system_parameters_all asp,

306: asp.org_id
307: INTO l_cash_basis_flag,
308: l_org_id
309: FROM ap_invoices_all ai,
310: ap_system_parameters_all asp,
311: gl_sets_of_books sob
312: WHERE ai.invoice_id = l_invoice_id
313: AND ai.org_id = asp.org_id
314: AND asp.set_of_books_id = sob.set_of_books_id;

Line 2046: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

2042: FUNCTION get_unposted_void_payment (P_invoice_id IN number)
2043: RETURN varchar2
2044: IS
2045: l_flag varchar2(1) := 'N';
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,

Line 2395: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;

2391: l_count_pmt_hist_posted NUMBER := 0;
2392: l_count_prepaid_posted NUMBER := 0;
2393: l_primary_acctg_method VARCHAR2(25);
2394: l_secondary_acctg_method VARCHAR2(25);
2395: l_org_id AP_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE;
2396: BEGIN
2397:
2398: select asp.accounting_method_option,
2399: nvl(asp.secondary_accounting_method, 'None'),

Line 2404: from ap_system_parameters_all asp

2400: asp.org_id
2401: into l_primary_acctg_method,
2402: l_secondary_acctg_method,
2403: l_org_id
2404: from ap_system_parameters_all asp
2405: where asp.org_id = P_org_id;
2406:
2407:
2408: /*-----------------------------------------------------------------+