APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_MC_DEPRN_PERIODS

Line 1901: fa_mc_deprn_periods dp1

1897:
1898: cursor MEM_EXP_RESERVE_MRC is
1899: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
1900: from fa_mc_deprn_summary ds1,
1901: fa_mc_deprn_periods dp1
1902: where ds1.book_type_code = h_book_type_code
1903: and ds1.asset_id = h_member_asset_id
1904: and dp1.book_type_code = ds1.book_type_Code
1905: and dp1.period_counter = ds1.period_counter

Line 1996: from fa_mc_deprn_periods dp1,

1992: and adj.source_type_code = 'ADJUSTMENT'
1993: and adj.set_of_books_id = h_set_of_books_id
1994: and adj.period_counter_adjusted in
1995: (select dp2.period_counter
1996: from fa_mc_deprn_periods dp1,
1997: fa_mc_deprn_periods dp2
1998: where dp1.book_type_code = adj.book_type_code
1999: and dp1.period_counter = h_period_counter - 1
2000: and dp1.set_of_books_id = h_set_of_books_id

Line 1997: fa_mc_deprn_periods dp2

1993: and adj.set_of_books_id = h_set_of_books_id
1994: and adj.period_counter_adjusted in
1995: (select dp2.period_counter
1996: from fa_mc_deprn_periods dp1,
1997: fa_mc_deprn_periods dp2
1998: where dp1.book_type_code = adj.book_type_code
1999: and dp1.period_counter = h_period_counter - 1
2000: and dp1.set_of_books_id = h_set_of_books_id
2001: and dp2.book_type_code = dp1.book_type_code

Line 2060: from fa_mc_deprn_periods

2056:
2057: else
2058:
2059: select fiscal_year into h_cur_fiscal_year
2060: from fa_mc_deprn_periods
2061: where book_type_code = h_book_type_code
2062: and period_counter = h_period_counter
2063: and set_of_books_id = h_set_of_books_id;
2064: