DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 119: FROM AP_System_Parameters_All ASP,

115: IF (l_xla_event_rec.entity_code = 'AP_PAYMENTS') THEN
116: BEGIN
117: SELECT ASP.Base_Currency_Code, AC.Currency_Code --8288996
118: INTO g_base_currency_code, l_check_curr_code
119: FROM AP_System_Parameters_All ASP,
120: AP_Checks_All AC
121: WHERE AC.Check_ID = l_xla_event_rec.source_id_int_1
122: AND AC.Org_ID = ASP.Org_ID;
123: EXCEPTION

Line 131: FROM AP_System_Parameters_All ASP,

127: ELSE
128:
129: SELECT ASP.Base_Currency_Code
130: INTO g_base_currency_code
131: FROM AP_System_Parameters_All ASP,
132: AP_Invoices_All AI
133: WHERE AI.Invoice_ID = l_xla_event_rec.source_id_int_1
134: AND AI.Org_ID = ASP.Org_ID;
135:

Line 2033: ap_system_parameters_all asp,

2029: -- check for non-reversed, upgrade payment clearing accounting w.r.t invoice_id
2030: select count(1)
2031: into l_upg_pay_actg_for_inv
2032: from ap_payment_history_all aph,
2033: ap_system_parameters_all asp,
2034: xla_ae_headers xah
2035: where aph.check_id in
2036: (select aip.check_id
2037: from ap_invoice_payments_all aip

Line 2065: ap_system_parameters_all asp,

2061: -- check for non-reversed, upgrade payment maturity accounting w.r.t invoice_id
2062: select count(1)
2063: into l_upg_pay_actg_for_inv
2064: from ap_payment_history_all aph,
2065: ap_system_parameters_all asp,
2066: xla_ae_headers xah
2067: where aph.check_id in
2068: (select aip.check_id
2069: from ap_invoice_payments_all aip

Line 2097: ap_system_parameters_all asp,

2093: -- check for non-reversed, upgrade payment accounting w.r.t invoice_id
2094: select count(1)
2095: into l_upg_pay_actg_for_inv
2096: from ap_payment_history_all aph,
2097: ap_system_parameters_all asp,
2098: xla_ae_headers xah
2099: where aph.check_id in
2100: (select aip.check_id
2101: from ap_invoice_payments_all aip

Line 2163: ap_system_parameters_all asp,

2159: -- check for upgrade payment accounting w.r.t invoice_payment_id
2160: select count(1)
2161: into l_upg_pay_all_actg_for_inv
2162: from ap_payment_history_all aph,
2163: ap_system_parameters_all asp,
2164: xla_ae_headers xah
2165: where aph.check_id in
2166: (select aip.check_id
2167: from ap_invoice_payments_all aip