APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_EXT_INV_RETIREMENTS

Line 319: from fa_ext_inv_retirements ext ,

315:
316: /** commented out for bugfix 2036777
317: Cursor Source_Lines_C Is
318: Select ext.*
319: from fa_ext_inv_retirements ext ,
320: fa_asset_invoices ai
321: where ext.mass_external_retire_id = L_Mass_External_Retire_ID
322: and ext.source_line_id = ai.source_line_id
323: and ai.date_ineffective is null

Line 333: from fa_ext_inv_retirements ext,

329: -- modified after 2036777, added fa_ai, so only invoices belonging
330: -- to current asset are treated.
331: Cursor Source_Lines_C Is
332: select ext.*, ext.ROWID row_id
333: from fa_ext_inv_retirements ext,
334: fa_asset_invoices ai
335: where ext.mass_external_retire_id = G_Mass_External_Retire_ID
336: and ext.source_line_id = ai.source_line_id
337: and ai.asset_id = g_asset_id

Line 978: update fa_ext_inv_retirements

974: l_inv_rec.fixed_assets_cost := source_lines_rec.cost_retired;
975: end if;
976: l_inv_rec.inv_indicator := k;
977:
978: update fa_ext_inv_retirements
979: set source_line_id_retired = l_inv_rec.source_line_id
980: where source_line_id = l_inv_rec.source_line_id;
981:
982: l_inv_tbl(k) := l_inv_rec;

Line 1595: from fa_ext_inv_retirements

1591: Fetch Assets_C into LV_Mass_External_Retire_ID;
1592: Exit when Assets_C%NOTFOUND;
1593:
1594: Select count(*) into LV_Inv_Count
1595: from fa_ext_inv_retirements
1596: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1597:
1598: if LV_Inv_Count > 0 then
1599: Delete from fa_ext_inv_retirements

Line 1599: Delete from fa_ext_inv_retirements

1595: from fa_ext_inv_retirements
1596: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1597:
1598: if LV_Inv_Count > 0 then
1599: Delete from fa_ext_inv_retirements
1600: where mass_external_retire_id = LV_Mass_External_Retire_ID;
1601: end if;
1602:
1603: Delete from fa_mass_ext_retirements