[Home] [Help]
530: if(H_MRCSOBTYPE <> 'R') then -- MRC
531: /*Bug#9375920 Modified the cursor to fetch change in cost because of member reclass in/out */
532: SELECT NVL(SUM(bk.cost - bk_old.cost),0)
533: INTO l_group_reclass_cost_in_out
534: FROM fa_books bk,
535: fa_books bk_old,
536: fa_transaction_headers fth,
537: fa_book_controls bc,
538: fa_deprn_periods dp
531: /*Bug#9375920 Modified the cursor to fetch change in cost because of member reclass in/out */
532: SELECT NVL(SUM(bk.cost - bk_old.cost),0)
533: INTO l_group_reclass_cost_in_out
534: FROM fa_books bk,
535: fa_books bk_old,
536: fa_transaction_headers fth,
537: fa_book_controls bc,
538: fa_deprn_periods dp
539: WHERE bk.transaction_header_id_in = fth.transaction_header_id
676: AND NVL(l_group_rec.rule_name, ' ') = FA_RXGA_POSITIVE_REDUCTION THEN
677:
678: SELECT COUNT(*)
679: INTO l_non_cip_num
680: FROM fa_books bk, fa_additions ad
681: WHERE bk.book_type_code = p_book_type_code
682: AND bk.group_asset_id = l_group_rec.asset_id
683: AND ad.asset_type <> 'CIP'
684: AND bk.asset_id = ad.asset_id;
959: x_sql_stmt OUT NOCOPY VARCHAR2)
960: IS
961: BEGIN
962:
963: -- Subquery is to get fa_books and fa_deprn_summary,
964: -- which are used to calculate beginning NBV.
965: -- Subquery doesn't necessarily get the previous year info.
966: -- If there was no depreciation calculation in the previous year,
967: -- subquery gets the max period counter prior to the fiscal year.
967: -- subquery gets the max period counter prior to the fiscal year.
968: if(P_MRCSOBTYPE <> 'R') then -- MRC
969: x_sql_stmt := ' FROM
970: fa_additions ad,
971: fa_books bk,
972: fa_categories_b cat,
973: fa_deprn_basis_rules br,
974: fa_methods met,
975: fa_deprn_periods dp,
978: bk_pre.group_asset_id,
979: bk_pre.cost,
980: bk_pre.cip_cost,
981: ds_pre.deprn_reserve
982: FROM fa_books bk_pre,
983: fa_deprn_summary ds_pre,
984: fa_deprn_periods dp_pre,
985: fa_additions ad_pre
986: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
1073: x_sql_stmt OUT NOCOPY VARCHAR2)
1074: IS
1075: BEGIN
1076:
1077: -- This where clause ges fa_books, which corresponds to
1078: -- the last depreciated period in the fiscal year.
1079:
1080: -- This also gets fa_deprn_summary no matter what.
1081: -- There is at least deprn_source_code = 'BOOKS' row for every asset.
1271: FROM fa_adjustments adj,
1272: fa_book_controls bc,
1273: fa_fiscal_year fy,
1274: fa_transaction_headers thm,
1275: fa_books bkm
1276: WHERE bkm.group_asset_id = ' || p_group_rec.asset_id || '
1277: AND adj.asset_id = bkm.asset_id
1278: AND bkm.transaction_header_id_in = thm.transaction_header_id
1279: AND adj.book_type_code = ''' || p_info_rec.book_type_code || '''
1375: FROM fa_retirements ret,
1376: fa_book_controls bc,
1377: fa_fiscal_year fy,
1378: fa_transaction_headers thm,
1379: fa_books bkm
1380: WHERE bkm.group_asset_id = ' || p_group_asset_id || '
1381: AND bc.book_type_code = ''' || p_info_rec.book_type_code || '''
1382: AND fy.fiscal_year = ' || p_info_rec.fiscal_year || '
1383: AND fy.fiscal_year_name = bc.fiscal_year_name
1696: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1697: INTO l_group_reclass_out
1698: FROM fa_adjustments adj,
1699: fa_transaction_headers thg,
1700: fa_books bkm
1701: WHERE adj.asset_id = p_group_rec.asset_id
1702: AND adj.book_type_code = p_info_rec.book_type_code
1703: AND thg.transaction_header_id = adj.transaction_header_id
1704: AND adj.period_counter_created
1755: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1756: INTO l_group_reclass_in
1757: FROM fa_adjustments adj,
1758: fa_transaction_headers thg,
1759: fa_books bkm
1760: WHERE adj.asset_id = p_group_rec.asset_id
1761: AND adj.book_type_code = p_info_rec.book_type_code
1762: AND thg.transaction_header_id = adj.transaction_header_id
1763: AND adj.period_counter_created