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_EXRATE_OPTIONS

Line 1161: FROM AP_POL_EXRATE_OPTIONS_ALL ex,

1157: SELECT ex.EXCHANGE_RATE_ID,
1158: ex.ORG_ID,
1159: pc.user_id,
1160: pc.selected_org_id
1161: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1162: AP_POL_CONTEXT pc
1163: WHERE ex.org_id(+) = pc.selected_org_id
1164: AND pc.user_id = p_user_id;
1165:

Line 1169: INSERT INTO ap_pol_exrate_options_all

1165:
1166: BEGIN
1167: FOR user_exrate_options_rec IN user_exrate_options_c LOOP
1168: IF user_exrate_options_rec.exchange_rate_id is null THEN
1169: INSERT INTO ap_pol_exrate_options_all
1170: (exchange_rate_id,
1171: enabled,
1172: default_exchange_rates,
1173: exchange_rate_type,

Line 1182: VALUES (AP_POL_EXRATE_OPTIONS_S.nextval,

1178: created_by,
1179: last_update_login,
1180: last_update_date,
1181: last_updated_by)
1182: VALUES (AP_POL_EXRATE_OPTIONS_S.nextval,
1183: 'N',
1184: 'N',
1185: 'Corporate',
1186: null,

Line 6227: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p

6223: l_location_id := getPolicyLocationId(p_expense_type_id, p_expense_date, p_location_id);
6224:
6225: select l.POLICY_LINE_ID
6226: INTO l_policy_line_id
6227: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p
6228: where p.parameter_id = p_expense_type_id
6229: AND h.policy_id = p.company_policy_id
6230: AND h.category_code <> 'MILEAGE'
6231: AND h.category_code <> 'PER_DIEM'