APPS.IGI_IGIIARRV_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 96: FA_TRANSACTION_HEADERS TH,

92: 'FA',
93: 1
94: FROM
95: FA_DISTRIBUTION_HISTORY DH,
96: FA_TRANSACTION_HEADERS TH,
97: FA_ASSET_HISTORY AH,
98: FA_ADJUSTMENTS AJ
99:
100: /* SLA Changes */

Line 1088: fa_transaction_headers th

1084: cp_asset_id fa_additions.asset_id%TYPE,
1085: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1086: SELECT ah.category_id
1087: FROM fa_asset_history ah,
1088: fa_transaction_headers th
1089: WHERE ah.asset_id = cp_asset_id
1090: AND th.transaction_header_id = cp_transaction_id
1091: AND th.book_type_code = cp_book
1092: AND th.asset_id = cp_asset_id