APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_TRANSACTION_HEADERS

Line 15: -- APPS.IFA_TRANSACTION_HEADERS_HR_BRI

11: -- x_node_id = Parent_node_id
12: -- x_asset_id = asset_id
13: -- x_attribute = NULL
14: -- TRANSACTION to be called from trigger
15: -- APPS.IFA_TRANSACTION_HEADERS_HR_BRI
16: -- x_book_type_code = NEW.book_type_code
17: -- x_asset_id = NEW.asset_id
18: -- x_attribute= NULL
19: -- HIERARCHY to be called from any hierarchy process

Line 884: FROM FA_TRANSACTION_HEADERS fth

880: BETWEEN fcbd.start_dpis
881: AND nvl(TO_DATE(fcbd.end_dpis, 'DD-MM-YYYY'),
882: TO_DATE('31-12-4712', 'DD-MM-YYYY'))
883: AND EXISTS (SELECT 'X'
884: FROM FA_TRANSACTION_HEADERS fth
885: WHERE fth.asset_id = fab.asset_id
886: AND fth.book_type_code = fab.book_type_code
887: AND (fth.transaction_date_entered <= x_Retire_Date
888: AND fth.transaction_type_code not in ('FULL RETIREMENT',

Line 949: FROM FA_TRANSACTION_HEADERS fth

945: BETWEEN fcbd.start_dpis
946: AND nvl(TO_DATE(fcbd.end_dpis, 'DD-MM-YYYY'),
947: TO_DATE('31-12-4712', 'DD-MM-YYYY'))
948: AND EXISTS (SELECT 'X'
949: FROM FA_TRANSACTION_HEADERS fth
950: WHERE fth.asset_id = fab.asset_id
951: AND fth.book_type_code = fab.book_type_code
952: AND (fth.transaction_date_entered <= x_Retire_Date
953: AND fth.transaction_type_code not in ('FULL RETIREMENT',