2078:
2079:
2080: cursor c_get_all_elig_fac(cp_enabled_flag_y VARCHAR2) IS
2081: select flp.location_id
2082: from fte_location_parameters flp
2083: where flp.include_mileage_flag = cp_enabled_flag_y;
2084:
2085:
2086: cursor c_get_region_for_facility(cp_location_id NUMBER,
2151: where region_id = cp_region_id;
2152:
2153: cursor c_check_mile_flag(cp_location_id NUMBER) IS
2154: select include_mileage_flag
2155: from fte_location_parameters
2156: where location_id = cp_location_id;
2157:
2158:
2159: