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_ALL

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 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 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 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';