APPS.AP_WEB_EXPENSE_WF dependencies on AP_POL_CAT_OPTIONS

Line 13081: l_ou_distance_field AP_POL_CAT_OPTIONS.DISTANCE_FIELD%TYPE;

13077: l_schedule_line_array AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array;
13078: l_orig_cum_mileage AP_WEB_EMPLOYEE_INFO.VALUE_TYPE%TYPE;
13079: i NUMBER := 1;
13080: j NUMBER := 1;
13081: l_ou_distance_field AP_POL_CAT_OPTIONS.DISTANCE_FIELD%TYPE;
13082: l_threshold_tolerance NUMBER := 0;
13083:
13084: c_schedule_line_cursor AP_WEB_DB_SCHLINE_PKG.ScheduleLinesCursor;
13085:

Line 13196: FROM AP_POL_CAT_OPTIONS

13192: -- Bug 8813146 - Threshold tolerance is used when daily_distance is used or distance_uom's used are different
13193: Begin
13194: SELECT DISTANCE_FIELD
13195: INTO l_ou_distance_field
13196: FROM AP_POL_CAT_OPTIONS
13197: WHERE category_code = 'MILEAGE';
13198: exception
13199: when no_data_found then
13200: l_ou_distance_field := C_DISTANCE_FIELD;

Line 13534: l_ou_distance_field AP_POL_CAT_OPTIONS.DISTANCE_FIELD%TYPE;

13530: l_insert_index NUMBER := p_mileage_line_array_count + 1;
13531: l_added_total NUMBER := 0;
13532: l_sl_array_count NUMBER := 0;
13533: l_debug_info VARCHAR2(200);
13534: l_ou_distance_field AP_POL_CAT_OPTIONS.DISTANCE_FIELD%TYPE;
13535: l_threshold_tolerance NUMBER := 0;
13536:
13537:
13538: BEGIN

Line 13593: FROM AP_POL_CAT_OPTIONS

13589: -- Bug 8813146 - Threshold tolerance is used when daily_distance is used or distance_uom's used are different
13590: Begin
13591: SELECT DISTANCE_FIELD
13592: INTO l_ou_distance_field
13593: FROM AP_POL_CAT_OPTIONS
13594: WHERE category_code = 'MILEAGE';
13595: exception
13596: when no_data_found then
13597: l_ou_distance_field := C_DISTANCE_FIELD;