DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_SYSTEM_PARAMETERS

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'