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_WEB_POLICY_UTILS dependencies on AP_POL_LOCATIONS_B

Line 683: WHERE exists (select 'x' from ap_pol_locations_b);

679:
680: CURSOR locations_defined_cur IS
681: SELECT 'Y'
682: FROM dual
683: WHERE exists (select 'x' from ap_pol_locations_b);
684: l_locations_defined VARCHAR2(1);
685:
686: CURSOR missing_translations_cur IS
687: SELECT count(1) missing_translation_count

Line 4410: from ap_pol_locations_b);

4406: select 1 location_count
4407: from dual
4408: where exists
4409: (select 1
4410: from ap_pol_locations_b);
4411:
4412: location_rec location_cur%ROWTYPE;
4413: BEGIN
4414:

Line 6154: from AP_POL_SCHEDULE_OPTIONS opts, AP_POL_LOCATIONS_B loc1, AP_POL_LOCATIONS_B loc2, ap_expense_report_params_all p

6150: AND (opts.end_date is null OR opts.end_date >= p_expense_date)
6151: AND LOCATION_ID = p_location_id
6152: UNION ALL
6153: select opts.location_id
6154: from AP_POL_SCHEDULE_OPTIONS opts, AP_POL_LOCATIONS_B loc1, AP_POL_LOCATIONS_B loc2, ap_expense_report_params_all p
6155: where p.parameter_id = p_expense_type_id
6156: AND policy_id = p.company_policy_id
6157: AND opts.option_type = 'LOCATION'
6158: AND opts.status = 'ACTIVE'

Line 6168: from AP_POL_SCHEDULE_OPTIONS opts, AP_POL_LOCATIONS_B loc, ap_expense_report_params_all p

6164: AND loc2.location_id = p_location_id
6165: UNION ALL
6166: -- Will find the all other location for a given policy
6167: select loc.location_id
6168: from AP_POL_SCHEDULE_OPTIONS opts, AP_POL_LOCATIONS_B loc, ap_expense_report_params_all p
6169: where p.parameter_id = p_expense_type_id
6170: AND opts.policy_id = p.company_policy_id
6171: AND opts.option_type = 'LOCATION'
6172: AND opts.status = 'ACTIVE'