APPS.EAM_CAP_MAIN_COST_PVT dependencies on FA_DEPRN_PERIODS

Line 86: from fa_deprn_periods dp,

82: CURSOR c_curr_dep_prd (c_book_type_code IN varchar) IS
83: Select dp.period_name,
84: bc.last_deprn_run_date,
85: bc.deprn_calendar
86: from fa_deprn_periods dp,
87: fa_deprn_periods dp2,
88: fa_deprn_periods dp3,
89: fa_book_controls bc
90: where dp.book_type_code =c_book_type_code

Line 87: fa_deprn_periods dp2,

83: Select dp.period_name,
84: bc.last_deprn_run_date,
85: bc.deprn_calendar
86: from fa_deprn_periods dp,
87: fa_deprn_periods dp2,
88: fa_deprn_periods dp3,
89: fa_book_controls bc
90: where dp.book_type_code =c_book_type_code
91: and dp.period_close_date is null

Line 88: fa_deprn_periods dp3,

84: bc.last_deprn_run_date,
85: bc.deprn_calendar
86: from fa_deprn_periods dp,
87: fa_deprn_periods dp2,
88: fa_deprn_periods dp3,
89: fa_book_controls bc
90: where dp.book_type_code =c_book_type_code
91: and dp.period_close_date is null
92: and dp2.book_type_code(+) = bc.distribution_source_book