eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 125: l_basecur ap_system_parameters.base_currency_code%TYPE;

121: current_calling_sequence VARCHAR2(2000);
122: debug_info VARCHAR2(100);
123: l_disc_amt_factor NUMBER;
124: l_disc_amt_divisor NUMBER; -- BUG 7000143
125: l_basecur ap_system_parameters.base_currency_code%TYPE;
126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;

Line 126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;

122: debug_info VARCHAR2(100);
123: l_disc_amt_factor NUMBER;
124: l_disc_amt_divisor NUMBER; -- BUG 7000143
125: l_basecur ap_system_parameters.base_currency_code%TYPE;
126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;

Line 128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;

124: l_disc_amt_divisor NUMBER; -- BUG 7000143
125: l_basecur ap_system_parameters.base_currency_code%TYPE;
126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;

Line 129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;

125: l_basecur ap_system_parameters.base_currency_code%TYPE;
126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
133:

Line 130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;

126: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
133:
134: BEGIN

Line 131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;

127: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
133:
134: BEGIN
135: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_distributions<-' ||

Line 132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;

128: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
129: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
130: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
131: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
132: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
133:
134: BEGIN
135: current_calling_sequence := 'AP_WITHHOLDING_PKG.Create_AWT_distributions<-' ||
136: P_Calling_Sequence;

Line 152: FROM ap_system_parameters_all asp,

148: l_combined_filing_flag,
149: l_income_tax_region_flag,
150: l_income_tax_region_asp,
151: l_basecur
152: FROM ap_system_parameters_all asp,
153: ap_invoices_all ai
154: WHERE ai.org_id = asp.org_id
155: and ai.invoice_id = p_invoice_id;
156:

Line 714: base_currency ap_system_parameters.base_currency_code%TYPE;

710: IS
711: new_invoice_id ap_invoices.invoice_id%TYPE;
712: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
713: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
714: base_currency ap_system_parameters.base_currency_code%TYPE;
715: new_invoice_base_descr ap_invoices.description%TYPE;
716: inv_terms_date DATE;
717: ta_terms_id po_vendor_sites.terms_id%TYPE;
718: ta_payment_priority po_vendor_sites.payment_priority%TYPE;

Line 871: ap_system_parameters_all p,

867: s.accts_pay_code_combination_id,
868: s.party_site_id,
869: pv.party_id
870: FROM ap_tax_codes_all t,
871: ap_system_parameters_all p,
872: po_vendor_sites_all s,
873: po_vendors pv
874: WHERE t.tax_id = TaxId
875: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */

Line 1766: FROM ap_system_parameters_all asp,

1762: l_create_invoices,
1763: l_awt_flag,
1764: l_inv_curr_code,
1765: l_org_id --4742265
1766: FROM ap_system_parameters_all asp,
1767: ap_invoices_all ai
1768: WHERE ai.org_id = asp.org_id
1769: and ai.invoice_id = p_invoice_id;
1770:

Line 1926: ap_system_parameters_all asp

1922: SELECT invoice_id
1923: , vendor_id
1924: , payment_num
1925: FROM ap_SELECTed_invoices_all ASI,
1926: ap_system_parameters_all asp
1927: WHERE checkrun_name = l_checkrun_name
1928: AND original_invoice_id IS NULL
1929: AND asp.org_id = asi.org_id
1930: and checkrun_id = l_checkrun_id

Line 2008: ap_system_parameters_all asp

2004: , NVL(asp.awt_include_discount_amt, 'N') include_discount_amt
2005: , asp.base_currency_code
2006: FROM ap_SELECTed_invoices_all ASI,
2007: ap_invoices_all AI,
2008: ap_system_parameters_all asp
2009: WHERE ASI.checkrun_name = l_checkrun_name
2010: AND asi.checkrun_id = l_checkrun_id
2011: AND AI.invoice_id = ASI.invoice_id
2012: AND AI.org_id = asp.org_id

Line 3151: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;

3147:
3148: rec_awt_dists c_awt_dists_pay%ROWTYPE;
3149:
3150: l_invoice_exchange_rate ap_invoices.exchange_rate%type;
3151: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;
3152: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;
3153:
3154: -- Ap_Undo_Withholding:
3155: -- PL/SQL Main Block PROCEDUREs AND functions:

Line 3212: ap_system_parameters_all ASP

3208: P_Awt_Date
3209: INTO gl_period_name,
3210: gl_awt_date
3211: FROM gl_period_statuses GPS,
3212: ap_system_parameters_all ASP
3213: WHERE GPS.application_id = 200
3214: AND GPS.set_of_books_id = ASP.set_of_books_id
3215: AND P_Awt_Date BETWEEN GPS.start_date AND GPS.END_date
3216: AND GPS.closing_status IN ('O', 'F')

Line 3593: FROM ap_system_parameters;

3589: debug_info := ' Fetching the functional currency AND exchange rate ' ;
3590:
3591: SELECT base_currency_code
3592: INTO l_func_currency_code
3593: FROM ap_system_parameters;
3594:
3595: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST')) THEN
3596: l_invoice_exchange_rate := rec_invoice.exchange_rate;
3597: ELSIF (P_Calling_Module = 'VOID PAYMENT') THEN

Line 3647: FROM ap_system_parameters;

3643: DECLARE
3644: CURSOR c_read_setup
3645: IS
3646: SELECT create_awt_invoices_type,create_awt_dists_type --bug7685907
3647: FROM ap_system_parameters;
3648: BEGIN
3649: debug_info := 'OPEN CURSOR c_read_setup';
3650: OPEN c_read_setup;
3651: