DBA Data[Home] [Help]

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 100: FROM FA_LOCATIONS

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