APPS.FA_MASS_RET_PUB dependencies on FA_ADDITIONS

Line 42: l_from_asset_no fa_additions_b.asset_number%TYPE;

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;
44:
45: l_msg_data varchar2(200);
46: l_loop_no number;

Line 43: l_to_asset_no fa_additions_b.asset_number%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;
44:
45: l_msg_data varchar2(200);
46: l_loop_no number;
47: l_yesno varchar2(10);

Line 120: fa_additions ad

116:
117: cursor c_fromasset is
118: Select 'Validated'
119: From fa_books bk,
120: fa_additions ad
121: Where ad.asset_number = l_from_asset_no
122: And ad.asset_id = bk.asset_id
123: And bk.book_type_code = l_book
124: And bk.date_ineffective is null;

Line 129: fa_additions ad

125:
126: cursor c_toasset is
127: Select 'Validated'
128: From fa_books bk,
129: fa_additions ad
130: Where ad.asset_number = l_to_asset_no
131: And ad.asset_id = bk.asset_id
132: And bk.book_type_code = l_book
133: And bk.date_ineffective is null;