APPS.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on FA_BOOKS

Line 89: CURSOR c_fully_reserved(cp_asset_id fa_books.asset_id%TYPE,

85: and adjustment_id = cp_adjustment_id
86: and period_counter = cp_period_counter;
87:
88: -- bug 3421734, start 1
89: CURSOR c_fully_reserved(cp_asset_id fa_books.asset_id%TYPE,
90: cp_book_type_code fa_books.book_type_code%TYPE)
91: IS
92: SELECT nvl(period_counter_fully_reserved, 0)
93: FROM fa_books

Line 90: cp_book_type_code fa_books.book_type_code%TYPE)

86: and period_counter = cp_period_counter;
87:
88: -- bug 3421734, start 1
89: CURSOR c_fully_reserved(cp_asset_id fa_books.asset_id%TYPE,
90: cp_book_type_code fa_books.book_type_code%TYPE)
91: IS
92: SELECT nvl(period_counter_fully_reserved, 0)
93: FROM fa_books
94: WHERE asset_id = cp_asset_id

Line 93: FROM fa_books

89: CURSOR c_fully_reserved(cp_asset_id fa_books.asset_id%TYPE,
90: cp_book_type_code fa_books.book_type_code%TYPE)
91: IS
92: SELECT nvl(period_counter_fully_reserved, 0)
93: FROM fa_books
94: WHERE asset_id = cp_asset_id
95: AND book_type_code = cp_book_type_code
96: AND transaction_header_id_out IS NULL
97: AND date_ineffective IS NULL;

Line 99: l_fully_reserved_pc fa_books.period_counter_fully_reserved%TYPE;

95: AND book_type_code = cp_book_type_code
96: AND transaction_header_id_out IS NULL
97: AND date_ineffective IS NULL;
98:
99: l_fully_reserved_pc fa_books.period_counter_fully_reserved%TYPE;
100: -- bug 3421734 end 1
101:
102: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
103: l_Transaction_Id NUMBER;