APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_DEPRN_PERIODS

Line 90: from fa_mc_deprn_periods

86: and period_num=P_period_counter;
87:
88: cursor GET_PERIOD_COUNTER_MRC is
89: select period_counter
90: from fa_mc_deprn_periods
91: where book_type_code=P_book_type_code
92: and fiscal_year=P_fiscal_year
93: and period_num=P_period_counter
94: and set_of_books_id = h_set_of_books_id;

Line 641: fa_mc_deprn_periods dp,

637: ds.bonus_ytd_deprn
638: from fa_track_members tr,
639: fa_mc_books bk,
640: fa_mc_deprn_summary ds,
641: fa_mc_deprn_periods dp,
642: fa_additions_b ad
643: where tr.group_asset_id = h_group_asset_id
644: and tr.period_counter = h_period_counter
645: and tr.fiscal_year = h_fiscal_year

Line 691: from fa_mc_deprn_periods

687: and period_counter = p_period_counter;
688:
689: cursor GET_PERIOD_NUM_MRC(p_period_counter number) is
690: select period_num
691: from fa_mc_deprn_periods
692: where book_type_code = h_book_type_code
693: and period_counter = p_period_counter
694: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);
695:

Line 1609: from fa_mc_deprn_periods

1605: end if;
1606:
1607: -- Check fiscal year of populated deprn summary
1608: select fiscal_year into h_ds_fy
1609: from fa_mc_deprn_periods
1610: where book_type_code = h_book_type_code
1611: and period_counter = mem.period_counter
1612: and set_of_books_id = h_set_of_books_id;
1613:

Line 3107: from fa_mc_deprn_periods

3103: and period_counter = p_per_counter;
3104:
3105: cursor GET_PERIOD_NUM_MRC(p_per_counter number) is
3106: select period_num
3107: from fa_mc_deprn_periods
3108: where book_type_code = P_book_type_code
3109: and period_counter = p_per_counter
3110: and nvl(set_of_books_id,-99) = nvl(h_set_of_books_id,-99);
3111:

Line 5888: from fa_mc_deprn_periods

5884: and period_counter = h_loop_period_counter;
5885:
5886: cursor GET_PERD_CLOSE_DATE_MRC is
5887: select nvl(calendar_period_close_date,sysdate)
5888: from fa_mc_deprn_periods
5889: where book_type_code = h_book_type_code
5890: and period_counter = h_loop_period_counter
5891: and set_of_books_id = h_set_of_books_id;
5892:

Line 5997: fa_mc_deprn_periods dp,

5993: ds.bonus_deprn_reserve,
5994: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
5995: dp1.fiscal_year
5996: from fa_mc_books bk,
5997: fa_mc_deprn_periods dp,
5998: fa_mc_deprn_periods dp1,
5999: fa_mc_deprn_summary ds,
6000: fa_additions_b ad
6001: where dp.book_type_code = h_book_type_code

Line 5998: fa_mc_deprn_periods dp1,

5994: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
5995: dp1.fiscal_year
5996: from fa_mc_books bk,
5997: fa_mc_deprn_periods dp,
5998: fa_mc_deprn_periods dp1,
5999: fa_mc_deprn_summary ds,
6000: fa_additions_b ad
6001: where dp.book_type_code = h_book_type_code
6002: and dp.period_counter = h_loop_period_counter

Line 6089: fa_mc_deprn_periods dp,

6085: ds.bonus_deprn_reserve,
6086: ds.bonus_ytd_deprn,
6087: dp.fiscal_year
6088: from fa_mc_books bk,
6089: fa_mc_deprn_periods dp,
6090: fa_mc_deprn_summary ds,
6091: fa_additions_b ad
6092: where dp.book_type_code = h_book_type_code
6093: and dp.period_counter = h_loop_period_counter

Line 6132: fa_mc_deprn_periods dp

6128: cursor MEMBER_START_PERIOD_MRC is
6129: select bk.recoverable_cost,
6130: bk.salvage_value
6131: from fa_mc_books bk,
6132: fa_mc_deprn_periods dp
6133: where bk.book_type_code = h_book_type_code
6134: and bk.group_asset_id = h_member_asset_id
6135: and bk.set_of_books_id = h_set_of_books_id
6136: and bk.date_effective <= nvl(dp.period_close_date,sysdate)

Line 6140: and dp.period_num = (select max(period_num) from fa_mc_deprn_periods dp1

6136: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6137: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)
6138: and dp.book_type_code = bk.book_type_code
6139: and dp.fiscal_year = h_fiscal_year - 1
6140: and dp.period_num = (select max(period_num) from fa_mc_deprn_periods dp1
6141: where dp1.book_type_code = h_book_type_code
6142: and dp1.fiscal_year = h_fiscal_year - 1
6143: and dp1.set_of_books_id = h_set_of_books_id)
6144: and dp.set_of_books_id = h_set_of_books_id;

Line 6155: from fa_mc_deprn_periods

6151: and period_num = h_loop_end_period;
6152:
6153: cursor GET_PERIOD_MRC is
6154: select period_counter + 1
6155: from fa_mc_deprn_periods
6156: where book_type_code = h_book_type_code
6157: and fiscal_year = h_loop_end_year
6158: and period_num = h_loop_end_period
6159: and set_of_books_id = h_set_of_books_id;

Line 6246: from fa_mc_deprn_periods dp1,

6242: and adj.set_of_books_id = h_set_of_books_id
6243: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6244: and adj.period_counter_adjusted in
6245: (select dp2.period_counter
6246: from fa_mc_deprn_periods dp1,
6247: fa_mc_deprn_periods dp2
6248: where dp1.book_type_code = adj.book_type_code
6249: and dp1.period_counter = h_period_counter - 1
6250: and dp1.set_of_books_id = h_set_of_books_id

Line 6247: fa_mc_deprn_periods dp2

6243: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6244: and adj.period_counter_adjusted in
6245: (select dp2.period_counter
6246: from fa_mc_deprn_periods dp1,
6247: fa_mc_deprn_periods dp2
6248: where dp1.book_type_code = adj.book_type_code
6249: and dp1.period_counter = h_period_counter - 1
6250: and dp1.set_of_books_id = h_set_of_books_id
6251: and dp2.book_type_code = dp1.book_type_code

Line 7772: from fa_mc_deprn_periods

7768: and period_num = h_period_num;
7769:
7770: cursor GET_PERIOD_COUNTER_MRC is
7771: select period_counter
7772: from fa_mc_deprn_periods
7773: where book_type_code = h_book_type_code
7774: and fiscal_year = h_fiscal_year
7775: and period_num = h_period_num
7776: and set_of_books_id = h_set_of_books_id;

Line 8028: from fa_mc_deprn_periods

8024: and period_num = h_period_num;
8025:
8026: cursor GET_PERIOD_COUNTER_MRC is
8027: select period_counter
8028: from fa_mc_deprn_periods
8029: where book_type_code = h_book_type_code
8030: and fiscal_year = h_fiscal_year
8031: and period_num = h_period_num
8032: and set_of_books_id = h_set_of_books_id;