DBA Data[Home] [Help]

APPS.IGI_IGIIARRD_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 95: FA_TRANSACTION_HEADERS TH,

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

Line 1087: fa_transaction_headers th

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