DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on GL_CODE_COMBINATIONS

Line 888: , gl_code_combinations gcc

884: AND fth.transaction_type_code not in ('FULL RETIREMENT',
885: 'REINSTATEMENT')))
886: AND EXISTS ( SELECT 'X'
887: FROM fa_distribution_history fad
888: , gl_code_combinations gcc
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'

Line 953: , gl_code_combinations gcc

949: AND fth.transaction_type_code not in ('FULL RETIREMENT',
950: 'REINSTATEMENT')))
951: AND EXISTS ( SELECT 'X'
952: FROM fa_distribution_history fad
953: , gl_code_combinations gcc
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'