APPS.IGI_IGIIACSD_XMLP_PKG dependencies on FA_BOOKS

Line 570: FA_BOOKS BK

566: FA_DISTRIBUTION_HISTORY DH,
567: FA_DEPRN_DETAIL DD,
568: FA_ASSET_HISTORY AH,
569: FA_CATEGORY_BOOKS CB,
570: FA_BOOKS BK
571: WHERE
572: DH.Book_Type_Code = p_Distribution_Source_Book AND
573: DECODE(DD.Deprn_Source_Code, 'D', P_Period_Date,
574: p_Additions_Date) BETWEEN

Line 658: FA_BOOKS BK,

654: IGI_IAC_DET_BALANCES DD,
655: FA_ASSET_HISTORY AH,
656: FA_CATEGORY_BOOKS CB,
657: IGI_IAC_CATEGORY_BOOKS ICB,
658: FA_BOOKS BK,
659: IGI_IAC_TRANSACTION_HEADERS ITH
660: WHERE
661: DH.Book_Type_Code = p_Distribution_Source_Book AND
662: DD.Asset_ID = DH.Asset_ID AND

Line 780: FA_BOOKS BK,

776: IGI_IAC_DET_BALANCES DD,
777: FA_ASSET_HISTORY AH,
778: FA_CATEGORY_BOOKS CB,
779: IGI_IAC_CATEGORY_BOOKS ICB,
780: FA_BOOKS BK,
781: IGI_IAC_TRANSACTION_HEADERS ITH
782: WHERE
783: DH.Book_Type_Code = p_Distribution_Source_Book AND
784: DD.Asset_ID = DH.Asset_ID AND

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

973: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
974: l_distribution_ccid fa_distribution_history.code_combination_id%TYPE;
975:
976: /* Cursor for fetching all retirement, reinstatement transactions */
977: CURSOR c_get_transactions(cp_book fa_books.book_type_code%TYPE) IS
978: SELECT *
979: FROM igi_iac_transaction_headers
980: WHERE book_type_code = cp_book
981: AND period_counter BETWEEN p_period1_pc AND p_period2_pc

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

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

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

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

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

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

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

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

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

1063: AND sub_adj.adjustment_id = cp_curr_adj_id
1064: AND sub_adj.distribution_id = adj.distribution_id);
1065:
1066: /* Cursor to fetch the category for the asset */
1067: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1068: cp_asset_id fa_additions.asset_id%TYPE,
1069: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1070: SELECT ah.category_id
1071: FROM fa_asset_history ah,

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

1080: th.transaction_header_id);
1081:
1082: /* Cursor to fetch the revaluation reserve account for the book
1083: and the category */
1084: CURSOR c_get_account(cp_book fa_books.book_type_code%TYPE,
1085: cp_category_id igi_iac_category_books.category_id%TYPE,
1086: cp_report_type varchar2) IS
1087: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1088: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid