APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_EXRATE_OPTIONS

Line 1186: FROM AP_POL_EXRATE_OPTIONS_ALL ex,

1182: SELECT ex.EXCHANGE_RATE_ID,
1183: ex.ORG_ID,
1184: pc.user_id,
1185: pc.selected_org_id
1186: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1187: AP_POL_CONTEXT pc
1188: WHERE ex.org_id(+) = pc.selected_org_id
1189: AND pc.user_id = p_user_id;
1190:

Line 1194: INSERT INTO ap_pol_exrate_options_all

1190:
1191: BEGIN
1192: FOR user_exrate_options_rec IN user_exrate_options_c LOOP
1193: IF user_exrate_options_rec.exchange_rate_id is null THEN
1194: INSERT INTO ap_pol_exrate_options_all
1195: (exchange_rate_id,
1196: enabled,
1197: default_exchange_rates,
1198: exchange_rate_type,

Line 1207: VALUES (AP_POL_EXRATE_OPTIONS_S.nextval,

1203: created_by,
1204: last_update_login,
1205: last_update_date,
1206: last_updated_by)
1207: VALUES (AP_POL_EXRATE_OPTIONS_S.nextval,
1208: 'N',
1209: 'N',
1210: 'Corporate',
1211: null,

Line 6305: 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

6301: End If;
6302:
6303: select l.POLICY_LINE_ID
6304: INTO l_policy_line_id
6305: 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
6306: where p.parameter_id = p_expense_type_id
6307: AND h.policy_id = p.company_policy_id
6308: AND h.category_code <> 'MILEAGE'
6309: AND h.category_code <> 'PER_DIEM'