APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS

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 1099: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;

1095:
1096: currency_code ap_invoices.invoice_currency_code%TYPE;
1097: payment_currency_code ap_invoices.payment_currency_code%TYPE;
1098: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1099: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
1100: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
1101: invoice_number ap_invoices.invoice_num%TYPE;
1102: supplier_id ap_invoices.vendor_id%TYPE;
1103: supplier_site_id ap_invoices.vendor_site_id%TYPE;

Line 2097: ap_system_parameters ASP

2093: P_Awt_Date
2094: INTO gl_period_name,
2095: gl_awt_date
2096: FROM gl_period_statuses GPS,
2097: ap_system_parameters ASP
2098: WHERE GPS.application_id = 200
2099: AND GPS.set_of_books_id = ASP.set_of_books_id
2100: AND P_Awt_Date BETWEEN GPS.start_date
2101: AND GPS.end_date

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(+)

Line 2317: ap_system_parameters P

2313: +NVL(S.second_disc_amt_available, 0)
2314: +NVL(S.third_disc_amt_available, 0)) discount,
2315: P.disc_is_inv_less_tax_flag
2316: FROM ap_payment_schedules S,
2317: ap_system_parameters P
2318: WHERE S.invoice_id = InvId
2319: /* Next condition is to make ok the projected withholding screen */
2320: AND S.payment_num = NVL(PaymNum, S.payment_num)
2321: AND P.awt_include_discount_amt = 'N'