APPS.CSE_ASSET_MOVE_PKG dependencies on FA_RETIREMENTS

Line 584: SELECT 'X' FROM fa_retirements fr

580: AND fb.date_ineffective IS NULL
581: AND cia.asset_quantity > 0
582: AND cia.fa_sync_flag = 'Y'
583: AND NOT EXISTS (
584: SELECT 'X' FROM fa_retirements fr
585: WHERE fdh.retirement_id = fr.retirement_id
586: AND fr.status IN ('PENDING','ERROR'))
587: AND NOT EXISTS (
588: SELECT 'X' FROM fa_mass_ext_retirements fmer