DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_RETIREMENTS

Line 893: from fa_retirements frt,

889: WHERE fad.asset_id = faa.asset_id
890: AND fad.code_combination_id = gcc.code_combination_id
891: AND fad.date_ineffective IS NULL )
892: AND NOT EXISTS ( select 'X' --'PROCESSED RETIREMENT'
893: from fa_retirements frt,
894: fa_books fb
895: where frt.asset_id = fab.asset_id
896: AND frt.asset_id = fb.asset_id
897: AND frt.transaction_header_id_out is NULL

Line 958: from fa_retirements frt,

954: WHERE fad.asset_id = faa.asset_id
955: AND fad.code_combination_id = gcc.code_combination_id
956: AND fad.date_ineffective IS NULL )
957: AND NOT EXISTS ( select 'X' --'PROCESSED RETIREMENT'
958: from fa_retirements frt,
959: fa_books fb
960: where frt.asset_id = fab.asset_id
961: AND frt.asset_id = fb.asset_id
962: AND frt.transaction_header_id_out is NULL