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 224: l_basecur ap_system_parameters.base_currency_code%TYPE;

220: current_calling_sequence VARCHAR2(2000);
221: debug_info VARCHAR2(1000);
222: l_disc_amt_factor NUMBER;
223: l_disc_amt_divisor NUMBER; -- BUG 7000143
224: l_basecur ap_system_parameters.base_currency_code%TYPE;
225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;

Line 225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;

221: debug_info VARCHAR2(1000);
222: l_disc_amt_factor NUMBER;
223: l_disc_amt_divisor NUMBER; -- BUG 7000143
224: l_basecur ap_system_parameters.base_currency_code%TYPE;
225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;

Line 227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;

223: l_disc_amt_divisor NUMBER; -- BUG 7000143
224: l_basecur ap_system_parameters.base_currency_code%TYPE;
225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;

Line 228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;

224: l_basecur ap_system_parameters.base_currency_code%TYPE;
225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
232:

Line 229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;

225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
232:
233: l_period_name gl_period_statuses.period_name%TYPE; --added for bug 8266021

Line 230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;

226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
232:
233: l_period_name gl_period_statuses.period_name%TYPE; --added for bug 8266021
234:

Line 231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;

227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
231: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
232:
233: l_period_name gl_period_statuses.period_name%TYPE; --added for bug 8266021
234:
235: l_exchange_rate ap_checks_all.exchange_rate%type; -- added for bug 8590059

Line 274: FROM ap_system_parameters_all asp,

270: l_combined_filing_flag,
271: l_income_tax_region_flag,
272: l_income_tax_region_asp,
273: l_basecur
274: FROM ap_system_parameters_all asp,
275: ap_invoices_all ai
276: WHERE ai.org_id = asp.org_id
277: and ai.invoice_id = p_invoice_id;
278:

Line 509: ap_System_Parameters_All Asp

505:
506: SELECT DISTINCT gps.Period_Name
507: INTO l_period_name
508: FROM gl_Period_Statuses gps,
509: ap_System_Parameters_All Asp
510: WHERE gps.Application_Id = 200
511: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
512: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
513: AND rec_temp_lines.accounting_date BETWEEN Trunc(gps.Start_Date)

Line 1301: base_currency ap_system_parameters.base_currency_code%TYPE;

1297: IS
1298: new_invoice_id ap_invoices.invoice_id%TYPE;
1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;
1305: ta_payment_priority po_vendor_sites.payment_priority%TYPE;

Line 1670: ap_system_parameters_all p,

1666: s.accts_pay_code_combination_id,
1667: s.party_site_id,
1668: pv.party_id
1669: FROM ap_tax_codes_all t,
1670: ap_system_parameters_all p,
1671: po_vendor_sites_all s,
1672: po_vendors pv
1673: WHERE t.tax_id = TaxId
1674: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */

Line 1832: ap_System_Parameters_All Asp

1828: automatic_offsets_flag
1829: INTO l_period_name,
1830: l_automatic_offsets
1831: FROM gl_Period_Statuses gps,
1832: ap_System_Parameters_All Asp
1833: WHERE gps.Application_Id = 200
1834: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
1835: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
1836: AND rec_awt_invs.accounting_date BETWEEN Trunc(gps.Start_Date)

Line 2758: FROM ap_system_parameters_all asp,

2754: l_create_invoices,
2755: l_awt_flag,
2756: l_inv_curr_code,
2757: l_org_id --4742265
2758: FROM ap_system_parameters_all asp,
2759: ap_invoices_all ai
2760: WHERE ai.org_id = asp.org_id
2761: and ai.invoice_id = p_invoice_id;
2762:

Line 2949: ap_system_parameters_all asp

2945: SELECT invoice_id
2946: , vendor_id
2947: , payment_num
2948: FROM ap_SELECTed_invoices_all ASI,
2949: ap_system_parameters_all asp
2950: WHERE checkrun_name = l_checkrun_name
2951: AND original_invoice_id IS NULL
2952: AND asp.org_id = asi.org_id
2953: and checkrun_id = l_checkrun_id

Line 3044: ap_system_parameters_all asp

3040: , asp.base_currency_code
3041: , NVL(ASI.payment_exchange_rate,1) payment_exchange_rate --bug 8590059
3042: FROM ap_SELECTed_invoices_all ASI,
3043: ap_invoices_all AI,
3044: ap_system_parameters_all asp
3045: WHERE ASI.checkrun_name = l_checkrun_name
3046: AND asi.checkrun_id = l_checkrun_id
3047: AND AI.invoice_id = ASI.invoice_id
3048: AND AI.org_id = asp.org_id

Line 4594: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;

4590: rec_awt_gross_dists c_awt_gross_dists_pay%ROWTYPE;
4591: --Bug12594549
4592:
4593: l_invoice_exchange_rate ap_invoices.exchange_rate%type;
4594: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;
4595: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;
4596:
4597: l_pay_awt_invs_count NUMBER; /* Bug 10353952 */
4598:

Line 4665: ap_system_parameters_all ASP

4661: P_Awt_Date
4662: INTO gl_period_name,
4663: gl_awt_date
4664: FROM gl_period_statuses GPS,
4665: ap_system_parameters_all ASP
4666: WHERE GPS.application_id = 200
4667: AND GPS.set_of_books_id = ASP.set_of_books_id
4668: AND P_Awt_Date BETWEEN GPS.start_date AND GPS.END_date
4669: AND GPS.closing_status IN ('O', 'F')

Line 4817: FROM ap_system_parameters

4813: END IF;
4814:
4815: SELECT base_currency_code
4816: INTO l_func_currency_code
4817: FROM ap_system_parameters
4818: WHERE org_id = l_org_id;
4819:
4820: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST')) THEN
4821: l_invoice_exchange_rate := rec_invoice.exchange_rate;

Line 5395: FROM ap_system_parameters

5391: END IF;
5392:
5393: SELECT base_currency_code
5394: INTO l_func_currency_code
5395: FROM ap_system_parameters
5396: WHERE org_id = l_org_id;
5397:
5398: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST')) THEN
5399: l_invoice_exchange_rate := rec_invoice.exchange_rate;

Line 5471: FROM ap_system_parameters_all

5467: DECLARE
5468: CURSOR c_read_setup(p_org_id in NUMBER) --bug14404025
5469: IS
5470: SELECT create_awt_invoices_type,create_awt_dists_type --bug7685907
5471: FROM ap_system_parameters_all
5472: where org_id = p_org_id; --bug14404025
5473:
5474: BEGIN
5475: debug_info := 'OPEN CURSOR c_read_setup';