eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IGIIAOPD_XMLP_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 177: IGI_IAC_TRANSACTION_HEADERS TH,

173: 'IAC',
174: 2
175: FROM
176: FA_DISTRIBUTION_HISTORY DH,
177: IGI_IAC_TRANSACTION_HEADERS TH,
178: IGI_IAC_ADJUSTMENTS AJ
179: WHERE
180: DH.Book_Type_Code = p_Distribution_Source_Book AND
181: AJ.Asset_ID = DH.Asset_ID AND

Line 228: IGI_IAC_TRANSACTION_HEADERS TH,

224: 'IAC',
225: 2
226: FROM
227: FA_DISTRIBUTION_HISTORY DH,
228: IGI_IAC_TRANSACTION_HEADERS TH,
229: IGI_IAC_ADJUSTMENTS AJ
230: WHERE
231: DH.Book_Type_Code = p_Distribution_Source_Book AND
232: AJ.Asset_ID = DH.Asset_ID AND

Line 317: IGI_IAC_TRANSACTION_HEADERS TH,

313: l_data_source,
314: l_display_order
315: FROM
316: FA_DISTRIBUTION_HISTORY DH,
317: IGI_IAC_TRANSACTION_HEADERS TH,
318: IGI_IAC_ADJUSTMENTS AJ
319: WHERE
320: DH.Book_Type_Code = p_Distribution_Source_Book AND
321: AJ.Asset_ID = DH.Asset_ID AND

Line 361: IGI_IAC_TRANSACTION_HEADERS TH,

357: l_data_source,
358: l_display_order
359: FROM
360: FA_DISTRIBUTION_HISTORY DH,
361: IGI_IAC_TRANSACTION_HEADERS TH,
362: IGI_IAC_ADJUSTMENTS AJ,
363: IGI_IAC_ADJUSTMENTS SUB_AJ
364: WHERE
365: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 419: IGI_IAC_TRANSACTION_HEADERS TH,

415: l_data_source,
416: l_display_order
417: FROM
418: FA_DISTRIBUTION_HISTORY DH,
419: IGI_IAC_TRANSACTION_HEADERS TH,
420: IGI_IAC_ADJUSTMENTS AJ
421: WHERE
422: DH.Book_Type_Code = p_Distribution_Source_Book AND
423: AJ.Asset_ID = DH.Asset_ID AND

Line 675: IGI_IAC_TRANSACTION_HEADERS ITH

671: FA_ASSET_HISTORY AH,
672: FA_CATEGORY_BOOKS CB,
673: IGI_IAC_CATEGORY_BOOKS ICB,
674: FA_BOOKS BK,
675: IGI_IAC_TRANSACTION_HEADERS ITH
676: WHERE
677: DH.Book_Type_Code = p_Distribution_Source_Book AND
678: DD.Asset_ID = DH.Asset_ID AND
679: DD.Book_Type_Code = p_Book AND

Line 684: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

680: DD.Distribution_ID = DH.Distribution_ID AND
681: DD.Period_Counter <= p_Period_PC AND
682: DD.adjustment_id =
683: (SELECT MAX (SUB_TH.adjustment_id)
684: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
685: WHERE SUB_TH.Book_Type_Code = p_Book AND
686: SUB_TH.Asset_ID = DH.Asset_ID AND
687: SUB_TH.Period_Counter <= p_Period_PC AND
688: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 797: IGI_IAC_TRANSACTION_HEADERS ITH

793: FA_ASSET_HISTORY AH,
794: FA_CATEGORY_BOOKS CB,
795: IGI_IAC_CATEGORY_BOOKS ICB,
796: FA_BOOKS BK,
797: IGI_IAC_TRANSACTION_HEADERS ITH
798: WHERE
799: DH.Book_Type_Code = p_Distribution_Source_Book AND
800: DD.Asset_ID = DH.Asset_ID AND
801: DD.Book_Type_Code = p_Book AND

Line 806: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

802: DD.Distribution_ID = DH.Distribution_ID AND
803: DD.Period_Counter <= p_Period_PC AND
804: DD.adjustment_id =
805: (SELECT MAX (SUB_TH.adjustment_id)
806: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
807: WHERE SUB_TH.Book_Type_Code = p_Book AND
808: SUB_TH.Asset_ID = DH.Asset_ID AND
809: SUB_TH.Period_Counter <= p_Period_PC AND
810: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 989: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

985: p_period2_pc number,
986: p_report_type varchar2,
987: p_balance_type varchar2)
988: IS
989: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
990: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
991:
992: /* Cursor for fetching all retirement, reinstatement transactions */
993: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS

Line 995: FROM igi_iac_transaction_headers

991:
992: /* Cursor for fetching all retirement, reinstatement transactions */
993: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
994: SELECT *
995: FROM igi_iac_transaction_headers
996: WHERE book_type_code = cp_book
997: AND period_counter BETWEEN p_period1_pc AND p_period2_pc
998: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
999:

Line 1002: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

998: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
999:
1000: /* Cursor for fetching the transaction previous to retirement or reinstatement */
1001: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1002: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1003: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT max(adjustment_id)
1005: FROM igi_iac_transaction_headers
1006: WHERE book_type_code = cp_book

Line 1003: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

999:
1000: /* Cursor for fetching the transaction previous to retirement or reinstatement */
1001: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1002: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1003: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT max(adjustment_id)
1005: FROM igi_iac_transaction_headers
1006: WHERE book_type_code = cp_book
1007: AND asset_id = cp_asset_id

Line 1005: FROM igi_iac_transaction_headers

1001: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1002: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1003: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT max(adjustment_id)
1005: FROM igi_iac_transaction_headers
1006: WHERE book_type_code = cp_book
1007: AND asset_id = cp_asset_id
1008: AND adjustment_id < cp_adjustment_id
1009: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 1015: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1011: /* Cursor to fetch the general fund movement from previous transaction
1012: to current transaction for the distributions which exist in both
1013: transactions */
1014: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1015: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1016: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1017: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1018: SELECT curr_adj.distribution_id distribution_id,
1019: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,

Line 1016: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1012: to current transaction for the distributions which exist in both
1013: transactions */
1014: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1015: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1016: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1017: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1018: SELECT curr_adj.distribution_id distribution_id,
1019: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1020: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,

Line 1017: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1013: transactions */
1014: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1015: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1016: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1017: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1018: SELECT curr_adj.distribution_id distribution_id,
1019: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1020: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1021: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,

Line 1038: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1034: /* Cursor to fetch the general fund movement from previous transaction
1035: to current transaction for the distributions which exist only in the
1036: latest transaction */
1037: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1038: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1039: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1040: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1041: SELECT adj.distribution_id,
1042: adj.reval_reserve_cost reval_reserve_cost,

Line 1039: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1035: to current transaction for the distributions which exist only in the
1036: latest transaction */
1037: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1038: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1039: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1040: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1041: SELECT adj.distribution_id,
1042: adj.reval_reserve_cost reval_reserve_cost,
1043: adj.reval_reserve_backlog reval_reserve_backlog,

Line 1040: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1036: latest transaction */
1037: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1038: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1039: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1040: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1041: SELECT adj.distribution_id,
1042: adj.reval_reserve_cost reval_reserve_cost,
1043: adj.reval_reserve_backlog reval_reserve_backlog,
1044: adj.general_fund_acc general_fund,

Line 1062: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1058: /* Cursor to fetch the general fund movement from previous transaction
1059: to current transaction for the distributions which exist only in the
1060: previous transaction */
1061: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1062: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1063: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1064: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1065: SELECT adj.distribution_id,
1066: (adj.reval_reserve_cost * -1) reval_reserve_cost,

Line 1063: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1059: to current transaction for the distributions which exist only in the
1060: previous transaction */
1061: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1062: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1063: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1064: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1065: SELECT adj.distribution_id,
1066: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1067: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,

Line 1064: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1060: previous transaction */
1061: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1062: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1063: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1064: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1065: SELECT adj.distribution_id,
1066: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1067: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1068: (adj.general_fund_acc * -1) general_fund,

Line 1085: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS

1081:
1082: /* Cursor to fetch the category for the asset */
1083: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
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