APPS.IGI_IGIIAOPE_XMLP_PKG dependencies on FA_BOOKS

Line 572: FA_BOOKS BK

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

Line 660: FA_BOOKS BK,

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

Line 782: FA_BOOKS BK,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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