APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_TRANSACTION_HEADERS

Line 13: -- APPS.IFA_TRANSACTION_HEADERS_HR_BRI

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

Line 880: FROM FA_TRANSACTION_HEADERS fth

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

Line 945: FROM FA_TRANSACTION_HEADERS fth

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