APPS.FA_MAINT_PURGE_PKG dependencies on FA_ADDITIONS

Line 130: fa_additions ad

126:
127: /* cursor for assets_to_purge is
128: select me.schedule_id
129: from fa_maint_events me,
130: fa_additions ad
131: where ad.asset_number >= nvl(h_from_asset_number,ad.asset_number) and
132: ad.asset_number <= nvl(h_to_asset_number,ad.asset_number) and
133: ad.category_id = nvl(h_category_id,ad.category_id) and
134: ad.asset_id = me.asset_id and

Line 243: from fa_additions ad

239: me.status = nvl(h_status, me.status) and
240: me.maintenance_date between nvl(h_from_date,me.maintenance_date) and
241: nvl(h_to_date,me.maintenance_date) and
242: me.asset_id = (select ad.asset_id
243: from fa_additions ad
244: where ad.asset_number >= nvl(h_from_asset_number,ad.asset_number)
245: and ad.asset_number <= nvl(h_to_asset_number,ad.asset_number)
246: and ad.asset_category_id = nvl(h_category_id,ad.asset_category_id)
247: and ad.asset_id = me.asset_id);