APPS.IGI_IGIIARRV_XMLP_PKG dependencies on FA_BOOKS

Line 586: FA_BOOKS BK

582: FA_DISTRIBUTION_HISTORY DH,
583: FA_DEPRN_DETAIL DD,
584: FA_ASSET_HISTORY AH,
585: FA_CATEGORY_BOOKS CB,
586: FA_BOOKS BK
587: WHERE
588: DH.Book_Type_Code = p_Distribution_Source_Book AND
589: DECODE(DD.Deprn_Source_Code, 'D', P_Period_Date,
590: p_Additions_Date) BETWEEN

Line 674: FA_BOOKS BK,

670: IGI_IAC_DET_BALANCES DD,
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

Line 796: FA_BOOKS BK,

792: IGI_IAC_DET_BALANCES DD,
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

Line 993: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) 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
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

Line 1001: CURSOR c_get_Prev_transaction(cp_book fa_books.book_type_code%TYPE,

997: AND period_counter BETWEEN p_period1_pc AND p_period2_pc
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

Line 1014: CURSOR c_get_dists(cp_book fa_books.book_type_code%TYPE,

1010:
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,

Line 1037: CURSOR c_get_new_dists(cp_book fa_books.book_type_code%TYPE,

1033:
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,

Line 1061: CURSOR c_get_old_dists(cp_book fa_books.book_type_code%TYPE,

1057:
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,

Line 1083: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,

1079: AND sub_adj.adjustment_id = cp_curr_adj_id
1080: AND sub_adj.distribution_id = adj.distribution_id);
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,

Line 1100: CURSOR c_get_account(cp_book fa_books.book_type_code%TYPE,

1096: th.transaction_header_id);
1097:
1098: /* Cursor to fetch the revaluation reserve account for the book
1099: and the category */
1100: CURSOR c_get_account(cp_book fa_books.book_type_code%TYPE,
1101: cp_category_id igi_iac_category_books.category_id%TYPE,
1102: cp_report_type varchar2) IS
1103: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1104: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid