APPS.IGI_IGIIABLS_XMLP_PKG dependencies on FA_BOOKS

Line 591: FA_BOOKS BK

587: FA_DISTRIBUTION_HISTORY DH,
588: FA_DEPRN_DETAIL DD,
589: FA_ASSET_HISTORY AH,
590: FA_CATEGORY_BOOKS CB,
591: FA_BOOKS BK
592: WHERE
593: DH.Book_Type_Code = p_Distribution_Source_Book AND
594: DECODE(DD.Deprn_Source_Code, 'D', P_Period_Date,
595: p_Additions_Date) BETWEEN

Line 679: FA_BOOKS BK,

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

Line 801: FA_BOOKS BK,

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

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

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

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

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

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

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

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

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

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

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

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

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

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