APPS.FA_MASS_RET_PUB dependencies on FA_LOCATIONS

Line 39: l_location_id fa_locations.location_id%TYPE;

35: l_category_id fa_categories.category_id%TYPE;
36: l_retirement_type_code fa_mass_retirements.retirement_type_code%TYPE;
37: l_retirement_date date;
38: l_status fa_lookups_b.lookup_code%TYPE;
39: l_location_id fa_locations.location_id%TYPE;
40: l_employee_id number;
41: l_asset_key_id fa_mass_retirements.asset_key_id%TYPE;
42: l_from_asset_no fa_additions_b.asset_number%TYPE;
43: l_to_asset_no fa_additions_b.asset_number%TYPE;

Line 101: FROM FA_LOCATIONS

97:
98:
99: cursor c_loc is
100: SELECT 'Validated'
101: FROM FA_LOCATIONS
102: WHERE location_id = l_location_id
103: AND sysdate between nvl(start_date_active,sysdate -1)
104: and nvl(end_date_active, sysdate +1)
105: AND enabled_flag = 'Y';