APPS.FA_MASS_RET_PUB dependencies on FA_LOOKUPS

Line 38: l_status fa_lookups_b.lookup_code%TYPE;

34:
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;

Line 70: From fa_lookups

66: And category_id = l_category_id;
67:
68: cursor c_lu is
69: Select 'Validated'
70: From fa_lookups
71: Where lookup_type = 'RETIREMENT'
72: And lookup_code = l_retirement_type_code;
73:
74: cursor c_rd is

Line 92: FROM FA_LOOKUPS

88: BETWEEN start_date AND end_date;
89:
90: cursor c_status is
91: SELECT 'Validated'
92: FROM FA_LOOKUPS
93: WHERE LOOKUP_TYPE = 'MASS_TRX_STATUS'
94: AND LOOKUP_CODE = l_status
95: AND LOOKUP_CODE in ('NEW','PENDING','ON_HOLD'
96: );