APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;

903:
904: currency_code ap_invoices.invoice_currency_code%TYPE;
905: payment_currency_code ap_invoices.payment_currency_code%TYPE;
906: payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
907: FUNCTIONal_currency ap_system_parameters.base_currency_code%TYPE;
908: invoice_exchange_rate ap_invoices.exchange_rate%TYPE;
909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;

Line 1793: ap_system_parameters ASP

1789: P_Awt_Date
1790: INTO gl_period_name,
1791: gl_awt_date
1792: FROM gl_period_statuses GPS,
1793: ap_system_parameters ASP
1794: WHERE GPS.application_id = 200
1795: AND GPS.set_of_books_id = ASP.set_of_books_id
1796: AND P_Awt_Date BETWEEN GPS.start_date
1797: AND GPS.end_date

Line 1841: FROM ap_system_parameters

1837:
1838: debug_info := 'Get base currency code';
1839: SELECT base_currency_code
1840: INTO functional_currency
1841: FROM ap_system_parameters
1842: WHERE org_id = nvl(p_org_id,org_id); --4742265
1843:
1844: END Getting_Basic_Info;
1845:

Line 1863: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP

1859: FROM (select DECODE(AIP.create_awt_dists_type,'BOTH',decode(p_calling_module,'AUTOAPPROVAL',
1860: AID.awt_group_id,AID.pay_awt_group_id),
1861: 'PAYMENT',AID.pay_awt_group_id,AID.awt_group_id) group_id,
1862: AID.amount,AID.base_amount,AID.line_type_lookup_code
1863: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP
1864: where AID.invoice_id = InvId
1865: AND AID.org_id = AIP.org_id ) D,
1866: ap_awt_groups G
1867: where D.group_id = G.group_id(+)

Line 1952: ap_system_parameters P

1948: +NVL(S.second_disc_amt_available, 0)
1949: +NVL(S.third_disc_amt_available, 0)) discount,
1950: P.disc_is_inv_less_tax_flag
1951: FROM ap_payment_schedules S,
1952: ap_system_parameters P
1953: WHERE S.invoice_id = InvId
1954: /* Next condition is to make ok the projected withholding screen */
1955: AND S.payment_num = NVL(PaymNum, S.payment_num)
1956: AND P.awt_include_discount_amt = 'N'