[Home] [Help]
2119: --* Cursor to populate the member level amounts
2120: cursor MEM_EXP_RESERVE is
2121: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
2122: from fa_deprn_summary ds1,
2123: fa_deprn_periods dp1
2124: where ds1.book_type_code = h_book_type_code
2125: and ds1.asset_id = h_member_asset_id
2126: and dp1.book_type_code = ds1.book_type_Code
2127: and dp1.period_counter = ds1.period_counter
2157: and ret.asset_id = h_member_asset_id
2158: and ret.transaction_header_id_in in
2159: (select th1.transaction_header_id
2160: from fa_transaction_headers th1,
2161: fa_deprn_periods dp1,
2162: fa_deprn_periods dp3
2163: where th1.asset_id = ret.asset_id
2164: and dp1.book_type_code = h_book_type_code
2165: and dp1.fiscal_year =
2158: and ret.transaction_header_id_in in
2159: (select th1.transaction_header_id
2160: from fa_transaction_headers th1,
2161: fa_deprn_periods dp1,
2162: fa_deprn_periods dp3
2163: where th1.asset_id = ret.asset_id
2164: and dp1.book_type_code = h_book_type_code
2165: and dp1.fiscal_year =
2166: (select dp2.fiscal_year
2163: where th1.asset_id = ret.asset_id
2164: and dp1.book_type_code = h_book_type_code
2165: and dp1.fiscal_year =
2166: (select dp2.fiscal_year
2167: from fa_deprn_periods dp2
2168: where dp2.book_type_code = dp1.book_type_code
2169: and dp2.period_Counter = h_period_counter - 1)
2170: and dp1.period_num = 1
2171: and dp3.book_type_code = dp1.book_type_code
2182: and ret.set_of_books_id = h_set_of_books_id
2183: and ret.transaction_header_id_in in
2184: (select th1.transaction_header_id
2185: from fa_transaction_headers th1,
2186: fa_deprn_periods dp1,
2187: fa_deprn_periods dp3
2188: where th1.asset_id = ret.asset_id
2189: and dp1.book_type_code = h_book_type_code
2190: and dp1.fiscal_year =
2183: and ret.transaction_header_id_in in
2184: (select th1.transaction_header_id
2185: from fa_transaction_headers th1,
2186: fa_deprn_periods dp1,
2187: fa_deprn_periods dp3
2188: where th1.asset_id = ret.asset_id
2189: and dp1.book_type_code = h_book_type_code
2190: and dp1.fiscal_year =
2191: (select dp2.fiscal_year
2188: where th1.asset_id = ret.asset_id
2189: and dp1.book_type_code = h_book_type_code
2190: and dp1.fiscal_year =
2191: (select dp2.fiscal_year
2192: from fa_deprn_periods dp2
2193: where dp2.book_type_code = dp1.book_type_code
2194: and dp2.period_Counter = h_period_counter - 1)
2195: and dp1.period_num = 1
2196: and dp3.book_type_code = dp1.book_type_code
2209: and adj.adjustment_type = 'RESERVE'
2210: and adj.source_type_code = 'ADJUSTMENT'
2211: and adj.period_counter_adjusted in
2212: (select dp2.period_counter
2213: from fa_deprn_periods dp1,
2214: fa_deprn_periods dp2
2215: where dp1.book_type_code = adj.book_type_code
2216: and dp1.period_counter = h_period_counter - 1
2217: and dp2.book_type_code = dp1.book_type_code
2210: and adj.source_type_code = 'ADJUSTMENT'
2211: and adj.period_counter_adjusted in
2212: (select dp2.period_counter
2213: from fa_deprn_periods dp1,
2214: fa_deprn_periods dp2
2215: where dp1.book_type_code = adj.book_type_code
2216: and dp1.period_counter = h_period_counter - 1
2217: and dp2.book_type_code = dp1.book_type_code
2218: and dp2.fiscal_year = dp1.fiscal_year
2271: -- Get Reserve Amount between member's DPIS and current period -- For Source Group Reserve
2272: if p_mrc_sob_type_code <> 'R' then
2273:
2274: select fiscal_year into h_cur_fiscal_year
2275: from fa_deprn_periods
2276: where book_type_code = h_book_type_code
2277: and period_counter = h_period_counter;
2278:
2279: open MEM_EXP_RESERVE;
2356: if (p_mrc_sob_type_code <> 'R') then
2357:
2358: select period_Counter,fiscal_year
2359: into h_period_counter,h_amort_fiscal_year
2360: from fa_deprn_periods
2361: where book_type_Code= h_book_type_code
2362: and nvl(calendar_period_open_date,sysdate) <= h_amort_start_date
2363: and nvl(calendar_period_close_date,sysdate) >= h_amort_start_date;
2364: