APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 414: ap_system_parameters_all asp

410: SELECT SUM(amount), count(1)
411: FROM ap_invoice_distributions_all aid,
412: xla_events evnt,
413: xla_ae_headers xah,
414: ap_system_parameters_all asp
415: WHERE aid.accounting_event_id = p_acct_event_id
416: AND aid.accounting_event_id = evnt.event_id
417: AND evnt.event_type_code in ('INVOICE ADJUSTED',
418: 'CREDIT MEMO ADJUSTED',

Line 2148: FROM ap_system_parameters_all

2144:
2145: debug_info := 'Get base currency code';
2146: SELECT base_currency_code
2147: INTO functional_currency
2148: FROM ap_system_parameters_all
2149: WHERE org_id = g_org_id; --4742265
2150:
2151: END Getting_Basic_Info;
2152:

Line 2175: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP

2171: FROM (select DECODE(AIP.create_awt_dists_type,'BOTH',decode(p_calling_module,'AUTOAPPROVAL',
2172: AID.awt_group_id,AID.pay_awt_group_id),
2173: 'PAYMENT',AID.pay_awt_group_id,AID.awt_group_id) group_id,
2174: AID.amount,AID.base_amount,AID.line_type_lookup_code, AID.accounting_date /* Added AID.accounting_date for bug#6605368 */
2175: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP
2176: where AID.invoice_id = InvId
2177: AND AID.org_id = AIP.org_id ) D,
2178: ap_awt_groups G
2179: where D.group_id = G.group_id(+)