DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on GL_CODE_COMBINATIONS

Line 892: , gl_code_combinations gcc

888: AND fth.transaction_type_code not in ('FULL RETIREMENT',
889: 'REINSTATEMENT')))
890: AND EXISTS ( SELECT 'X'
891: FROM fa_distribution_history fad
892: , gl_code_combinations gcc
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'

Line 957: , gl_code_combinations gcc

953: AND fth.transaction_type_code not in ('FULL RETIREMENT',
954: 'REINSTATEMENT')))
955: AND EXISTS ( SELECT 'X'
956: FROM fa_distribution_history fad
957: , gl_code_combinations gcc
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'