DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_RETIREMENTS

Line 897: from fa_retirements frt,

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

Line 962: from fa_retirements frt,

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