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 119: fa_additions ad

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

Line 128: fa_additions ad

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