DBA Data[Home] [Help]

APPS.IGI_IGIIABLS_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 101: FA_TRANSACTION_HEADERS TH,

97: 'FA',
98: 1
99: FROM
100: FA_DISTRIBUTION_HISTORY DH,
101: FA_TRANSACTION_HEADERS TH,
102: FA_ASSET_HISTORY AH,
103: FA_ADJUSTMENTS AJ
104:
105: /* SLA Changes */

Line 1093: fa_transaction_headers th

1089: cp_asset_id fa_additions.asset_id%TYPE,
1090: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1091: SELECT ah.category_id
1092: FROM fa_asset_history ah,
1093: fa_transaction_headers th
1094: WHERE ah.asset_id = cp_asset_id
1095: AND th.transaction_header_id = cp_transaction_id
1096: AND th.book_type_code = cp_book
1097: AND th.asset_id = cp_asset_id