DBA Data[Home] [Help]

APPS.IGI_IGIIACSD_XMLP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 80: FA_TRANSACTION_HEADERS TH,

76: 'FA',
77: 1
78: FROM
79: FA_DISTRIBUTION_HISTORY DH,
80: FA_TRANSACTION_HEADERS TH,
81: FA_ASSET_HISTORY AH,
82: FA_ADJUSTMENTS AJ
83:
84: /* SLA Changes */

Line 1072: fa_transaction_headers th

1068: cp_asset_id fa_additions.asset_id%TYPE,
1069: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1070: SELECT ah.category_id
1071: FROM fa_asset_history ah,
1072: fa_transaction_headers th
1073: WHERE ah.asset_id = cp_asset_id
1074: AND th.transaction_header_id = cp_transaction_id
1075: AND th.book_type_code = cp_book
1076: AND th.asset_id = cp_asset_id