APPS.IGI_IGIIARRD_XMLP_PKG dependencies on FA_BOOKS

Line 585: FA_BOOKS BK

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

Line 673: FA_BOOKS BK,

669: IGI_IAC_DET_BALANCES DD,
670: FA_ASSET_HISTORY AH,
671: FA_CATEGORY_BOOKS CB,
672: IGI_IAC_CATEGORY_BOOKS ICB,
673: FA_BOOKS BK,
674: IGI_IAC_TRANSACTION_HEADERS ITH
675: WHERE
676: DH.Book_Type_Code = p_Distribution_Source_Book AND
677: DD.Asset_ID = DH.Asset_ID AND

Line 795: FA_BOOKS BK,

791: IGI_IAC_DET_BALANCES DD,
792: FA_ASSET_HISTORY AH,
793: FA_CATEGORY_BOOKS CB,
794: IGI_IAC_CATEGORY_BOOKS ICB,
795: FA_BOOKS BK,
796: IGI_IAC_TRANSACTION_HEADERS ITH
797: WHERE
798: DH.Book_Type_Code = p_Distribution_Source_Book AND
799: DD.Asset_ID = DH.Asset_ID AND

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

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

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

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

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

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

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

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

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

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

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

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

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

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