APPS.AP_WEB_POLICY_UTILS dependencies on AP_EXPENSE_REPORT_PARAMS_ALL

Line 4546: from ap_expense_report_params_all

4542: SELECT 1 INTO l_count_rows
4543: FROM dual
4544: WHERE exists
4545: (select 1
4546: from ap_expense_report_params_all
4547: where company_policy_id = p_policy_id and nvl(end_date,p_end_date+1) > p_end_date);
4548:
4549: END IF;
4550:

Line 4595: UPDATE ap_expense_report_params_all SET end_date = p_end_date

4591: BEGIN
4592: l_are_enddates_capped := are_exp_type_enddates_capped(p_policy_id, p_end_date);
4593:
4594: IF (l_are_enddates_capped = 'N') THEN
4595: UPDATE ap_expense_report_params_all SET end_date = p_end_date
4596: WHERE company_policy_id = p_policy_id and nvl(end_date,p_end_date+1) > p_end_date;
4597: commit;
4598: END IF;
4599:

Line 6145: from AP_POL_SCHEDULE_OPTIONS opts, ap_expense_report_params_all p

6141: INTO l_location_id
6142: FROM (
6143: -- This query verifies that a given location is active within a policy
6144: select location_id
6145: from AP_POL_SCHEDULE_OPTIONS opts, ap_expense_report_params_all p
6146: where p.parameter_id = p_expense_type_id
6147: AND policy_id = p.company_policy_id
6148: AND option_type = 'LOCATION'
6149: AND status = 'ACTIVE'

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'

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'