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_IGIIACST_XMLP_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 182: IGI_IAC_TRANSACTION_HEADERS TH,

178: 'IAC',
179: 2
180: FROM
181: FA_DISTRIBUTION_HISTORY DH,
182: IGI_IAC_TRANSACTION_HEADERS TH,
183: IGI_IAC_ADJUSTMENTS AJ
184: WHERE
185: DH.Book_Type_Code = p_Distribution_Source_Book AND
186: AJ.Asset_ID = DH.Asset_ID AND

Line 233: IGI_IAC_TRANSACTION_HEADERS TH,

229: 'IAC',
230: 2
231: FROM
232: FA_DISTRIBUTION_HISTORY DH,
233: IGI_IAC_TRANSACTION_HEADERS TH,
234: IGI_IAC_ADJUSTMENTS AJ
235: WHERE
236: DH.Book_Type_Code = p_Distribution_Source_Book AND
237: AJ.Asset_ID = DH.Asset_ID AND

Line 322: IGI_IAC_TRANSACTION_HEADERS TH,

318: l_data_source,
319: l_display_order
320: FROM
321: FA_DISTRIBUTION_HISTORY DH,
322: IGI_IAC_TRANSACTION_HEADERS TH,
323: IGI_IAC_ADJUSTMENTS AJ
324: WHERE
325: DH.Book_Type_Code = p_Distribution_Source_Book AND
326: AJ.Asset_ID = DH.Asset_ID AND

Line 366: IGI_IAC_TRANSACTION_HEADERS TH,

362: l_data_source,
363: l_display_order
364: FROM
365: FA_DISTRIBUTION_HISTORY DH,
366: IGI_IAC_TRANSACTION_HEADERS TH,
367: IGI_IAC_ADJUSTMENTS AJ,
368: IGI_IAC_ADJUSTMENTS SUB_AJ
369: WHERE
370: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 424: IGI_IAC_TRANSACTION_HEADERS TH,

420: l_data_source,
421: l_display_order
422: FROM
423: FA_DISTRIBUTION_HISTORY DH,
424: IGI_IAC_TRANSACTION_HEADERS TH,
425: IGI_IAC_ADJUSTMENTS AJ
426: WHERE
427: DH.Book_Type_Code = p_Distribution_Source_Book AND
428: AJ.Asset_ID = DH.Asset_ID AND

Line 680: IGI_IAC_TRANSACTION_HEADERS ITH

676: FA_ASSET_HISTORY AH,
677: FA_CATEGORY_BOOKS CB,
678: IGI_IAC_CATEGORY_BOOKS ICB,
679: FA_BOOKS BK,
680: IGI_IAC_TRANSACTION_HEADERS ITH
681: WHERE
682: DH.Book_Type_Code = p_Distribution_Source_Book AND
683: DD.Asset_ID = DH.Asset_ID AND
684: DD.Book_Type_Code = p_Book AND

Line 689: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

685: DD.Distribution_ID = DH.Distribution_ID AND
686: DD.Period_Counter <= p_Period_PC AND
687: DD.adjustment_id =
688: (SELECT MAX (SUB_TH.adjustment_id)
689: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
690: WHERE SUB_TH.Book_Type_Code = p_Book AND
691: SUB_TH.Asset_ID = DH.Asset_ID AND
692: SUB_TH.Period_Counter <= p_Period_PC AND
693: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 802: IGI_IAC_TRANSACTION_HEADERS ITH

798: FA_ASSET_HISTORY AH,
799: FA_CATEGORY_BOOKS CB,
800: IGI_IAC_CATEGORY_BOOKS ICB,
801: FA_BOOKS BK,
802: IGI_IAC_TRANSACTION_HEADERS ITH
803: WHERE
804: DH.Book_Type_Code = p_Distribution_Source_Book AND
805: DD.Asset_ID = DH.Asset_ID AND
806: DD.Book_Type_Code = p_Book AND

Line 811: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

807: DD.Distribution_ID = DH.Distribution_ID AND
808: DD.Period_Counter <= p_Period_PC AND
809: DD.adjustment_id =
810: (SELECT MAX (SUB_TH.adjustment_id)
811: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
812: WHERE SUB_TH.Book_Type_Code = p_Book AND
813: SUB_TH.Asset_ID = DH.Asset_ID AND
814: SUB_TH.Period_Counter <= p_Period_PC AND
815: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 994: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

990: p_period2_pc number,
991: p_report_type varchar2,
992: p_balance_type varchar2)
993: IS
994: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
995: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
996:
997: /* Cursor for fetching all retirement, reinstatement transactions */
998: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS

Line 1000: FROM igi_iac_transaction_headers

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

Line 1007: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

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

Line 1008: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

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

Line 1010: FROM igi_iac_transaction_headers

1006: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
1007: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1008: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1009: SELECT max(adjustment_id)
1010: FROM igi_iac_transaction_headers
1011: WHERE book_type_code = cp_book
1012: AND asset_id = cp_asset_id
1013: AND adjustment_id < cp_adjustment_id
1014: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 1020: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

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

Line 1021: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

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

Line 1022: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1018: transactions */
1019: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1020: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1021: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1022: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1023: SELECT curr_adj.distribution_id distribution_id,
1024: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1025: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1026: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,

Line 1043: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

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

Line 1044: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

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

Line 1045: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1041: latest transaction */
1042: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1043: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1044: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1045: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1046: SELECT adj.distribution_id,
1047: adj.reval_reserve_cost reval_reserve_cost,
1048: adj.reval_reserve_backlog reval_reserve_backlog,
1049: adj.general_fund_acc general_fund,

Line 1067: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

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

Line 1068: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

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

Line 1069: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1065: previous transaction */
1066: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1067: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1068: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1069: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1070: SELECT adj.distribution_id,
1071: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1072: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1073: (adj.general_fund_acc * -1) general_fund,

Line 1090: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS

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