APPS.IGI_IGIIABLD_XMLP_PKG dependencies on FA_BOOKS

Line 589: FA_BOOKS BK

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

Line 677: FA_BOOKS BK,

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

Line 799: FA_BOOKS BK,

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

Line 996: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS

992: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
993: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
994:
995: /* Cursor for fetching all retirement, reinstatement transactions */
996: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
997: SELECT *
998: FROM igi_iac_transaction_headers
999: WHERE book_type_code = cp_book
1000: AND period_counter BETWEEN p_period1_pc AND p_period2_pc

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

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

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

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

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

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

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

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

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

1082: AND sub_adj.adjustment_id = cp_curr_adj_id
1083: AND sub_adj.distribution_id = adj.distribution_id);
1084:
1085: /* Cursor to fetch the category for the asset */
1086: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1087: cp_asset_id fa_additions.asset_id%TYPE,
1088: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1089: SELECT ah.category_id
1090: FROM fa_asset_history ah,

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

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