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

Line 163: IGI_IAC_TRANSACTION_HEADERS TH,

159: 'IAC',
160: 2
161: FROM
162: FA_DISTRIBUTION_HISTORY DH,
163: IGI_IAC_TRANSACTION_HEADERS TH,
164: IGI_IAC_ADJUSTMENTS AJ
165: WHERE
166: DH.Book_Type_Code = p_Distribution_Source_Book AND
167: AJ.Asset_ID = DH.Asset_ID AND

Line 214: IGI_IAC_TRANSACTION_HEADERS TH,

210: 'IAC',
211: 2
212: FROM
213: FA_DISTRIBUTION_HISTORY DH,
214: IGI_IAC_TRANSACTION_HEADERS TH,
215: IGI_IAC_ADJUSTMENTS AJ
216: WHERE
217: DH.Book_Type_Code = p_Distribution_Source_Book AND
218: AJ.Asset_ID = DH.Asset_ID AND

Line 303: IGI_IAC_TRANSACTION_HEADERS TH,

299: l_data_source,
300: l_display_order
301: FROM
302: FA_DISTRIBUTION_HISTORY DH,
303: IGI_IAC_TRANSACTION_HEADERS TH,
304: IGI_IAC_ADJUSTMENTS AJ
305: WHERE
306: DH.Book_Type_Code = p_Distribution_Source_Book AND
307: AJ.Asset_ID = DH.Asset_ID AND

Line 347: IGI_IAC_TRANSACTION_HEADERS TH,

343: l_data_source,
344: l_display_order
345: FROM
346: FA_DISTRIBUTION_HISTORY DH,
347: IGI_IAC_TRANSACTION_HEADERS TH,
348: IGI_IAC_ADJUSTMENTS AJ,
349: IGI_IAC_ADJUSTMENTS SUB_AJ
350: WHERE
351: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 405: IGI_IAC_TRANSACTION_HEADERS TH,

401: l_data_source,
402: l_display_order
403: FROM
404: FA_DISTRIBUTION_HISTORY DH,
405: IGI_IAC_TRANSACTION_HEADERS TH,
406: IGI_IAC_ADJUSTMENTS AJ
407: WHERE
408: DH.Book_Type_Code = p_Distribution_Source_Book AND
409: AJ.Asset_ID = DH.Asset_ID AND

Line 661: IGI_IAC_TRANSACTION_HEADERS ITH

657: FA_ASSET_HISTORY AH,
658: FA_CATEGORY_BOOKS CB,
659: IGI_IAC_CATEGORY_BOOKS ICB,
660: FA_BOOKS BK,
661: IGI_IAC_TRANSACTION_HEADERS ITH
662: WHERE
663: DH.Book_Type_Code = p_Distribution_Source_Book AND
664: DD.Asset_ID = DH.Asset_ID AND
665: DD.Book_Type_Code = p_Book AND

Line 670: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

666: DD.Distribution_ID = DH.Distribution_ID AND
667: DD.Period_Counter <= p_Period_PC AND
668: DD.adjustment_id =
669: (SELECT MAX (SUB_TH.adjustment_id)
670: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
671: WHERE SUB_TH.Book_Type_Code = p_Book AND
672: SUB_TH.Asset_ID = DH.Asset_ID AND
673: SUB_TH.Period_Counter <= p_Period_PC AND
674: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 783: IGI_IAC_TRANSACTION_HEADERS ITH

779: FA_ASSET_HISTORY AH,
780: FA_CATEGORY_BOOKS CB,
781: IGI_IAC_CATEGORY_BOOKS ICB,
782: FA_BOOKS BK,
783: IGI_IAC_TRANSACTION_HEADERS ITH
784: WHERE
785: DH.Book_Type_Code = p_Distribution_Source_Book AND
786: DD.Asset_ID = DH.Asset_ID AND
787: DD.Book_Type_Code = p_Book AND

Line 792: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH

788: DD.Distribution_ID = DH.Distribution_ID AND
789: DD.Period_Counter <= p_Period_PC AND
790: DD.adjustment_id =
791: (SELECT MAX (SUB_TH.adjustment_id)
792: FROM IGI_IAC_TRANSACTION_HEADERS SUB_TH
793: WHERE SUB_TH.Book_Type_Code = p_Book AND
794: SUB_TH.Asset_ID = DH.Asset_ID AND
795: SUB_TH.Period_Counter <= p_Period_PC AND
796: SUB_TH.adjustment_status NOT IN ('PREVIEW','OBSOLETE')) AND

Line 975: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

971: p_period2_pc number,
972: p_report_type varchar2,
973: p_balance_type varchar2)
974: IS
975: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
976: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
977:
978: /* Cursor for fetching all retirement, reinstatement transactions */
979: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS

Line 981: FROM igi_iac_transaction_headers

977:
978: /* Cursor for fetching all retirement, reinstatement transactions */
979: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
980: SELECT *
981: FROM igi_iac_transaction_headers
982: WHERE book_type_code = cp_book
983: AND period_counter BETWEEN p_period1_pc AND p_period2_pc
984: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
985:

Line 988: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

984: AND transaction_type_code IN ('PARTIAL RETIRE', 'FULL RETIREMENT', 'REINSTATEMENT');
985:
986: /* Cursor for fetching the transaction previous to retirement or reinstatement */
987: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
988: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
989: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
990: SELECT max(adjustment_id)
991: FROM igi_iac_transaction_headers
992: WHERE book_type_code = cp_book

Line 989: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

985:
986: /* Cursor for fetching the transaction previous to retirement or reinstatement */
987: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
988: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
989: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
990: SELECT max(adjustment_id)
991: FROM igi_iac_transaction_headers
992: WHERE book_type_code = cp_book
993: AND asset_id = cp_asset_id

Line 991: FROM igi_iac_transaction_headers

987: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,
988: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
989: cp_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
990: SELECT max(adjustment_id)
991: FROM igi_iac_transaction_headers
992: WHERE book_type_code = cp_book
993: AND asset_id = cp_asset_id
994: AND adjustment_id < cp_adjustment_id
995: AND adjustment_status NOT IN ('PREVIEW','OBSOLETE');

Line 1001: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

997: /* Cursor to fetch the general fund movement from previous transaction
998: to current transaction for the distributions which exist in both
999: transactions */
1000: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1001: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1002: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1003: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT curr_adj.distribution_id distribution_id,
1005: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,

Line 1002: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

998: to current transaction for the distributions which exist in both
999: transactions */
1000: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1001: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1002: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1003: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT curr_adj.distribution_id distribution_id,
1005: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1006: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,

Line 1003: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

999: transactions */
1000: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,
1001: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1002: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1003: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1004: SELECT curr_adj.distribution_id distribution_id,
1005: (curr_adj.reval_reserve_cost - prev_adj.reval_reserve_cost) reval_reserve_cost,
1006: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1007: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,

Line 1024: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1020: /* Cursor to fetch the general fund movement from previous transaction
1021: to current transaction for the distributions which exist only in the
1022: latest transaction */
1023: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1024: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1025: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1026: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1027: SELECT adj.distribution_id,
1028: adj.reval_reserve_cost reval_reserve_cost,

Line 1025: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1021: to current transaction for the distributions which exist only in the
1022: latest transaction */
1023: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1024: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1025: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1026: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1027: SELECT adj.distribution_id,
1028: adj.reval_reserve_cost reval_reserve_cost,
1029: adj.reval_reserve_backlog reval_reserve_backlog,

Line 1026: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1022: latest transaction */
1023: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,
1024: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1025: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1026: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1027: SELECT adj.distribution_id,
1028: adj.reval_reserve_cost reval_reserve_cost,
1029: adj.reval_reserve_backlog reval_reserve_backlog,
1030: adj.general_fund_acc general_fund,

Line 1048: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

1044: /* Cursor to fetch the general fund movement from previous transaction
1045: to current transaction for the distributions which exist only in the
1046: previous transaction */
1047: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1048: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1049: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1050: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1051: SELECT adj.distribution_id,
1052: (adj.reval_reserve_cost * -1) reval_reserve_cost,

Line 1049: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,

1045: to current transaction for the distributions which exist only in the
1046: previous transaction */
1047: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1048: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1049: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1050: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1051: SELECT adj.distribution_id,
1052: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1053: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,

Line 1050: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1046: previous transaction */
1047: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,
1048: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
1049: cp_curr_adj_id igi_iac_transaction_headers.adjustment_id%TYPE,
1050: cp_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1051: SELECT adj.distribution_id,
1052: (adj.reval_reserve_cost * -1) reval_reserve_cost,
1053: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1054: (adj.general_fund_acc * -1) general_fund,

Line 1071: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS

1067:
1068: /* Cursor to fetch the category for the asset */
1069: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1070: cp_asset_id fa_additions.asset_id%TYPE,
1071: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1072: SELECT ah.category_id
1073: FROM fa_asset_history ah,
1074: fa_transaction_headers th
1075: WHERE ah.asset_id = cp_asset_id