DBA Data[Home] [Help]

APPS.EAM_CAP_MAIN_COST_PVT dependencies on FA_DEPRN_PERIODS

Line 75: from fa_deprn_periods dp,

71: CURSOR c_curr_dep_prd (c_book_type_code IN varchar) IS
72: Select dp.period_name,
73: bc.last_deprn_run_date,
74: bc.deprn_calendar
75: from fa_deprn_periods dp,
76: fa_deprn_periods dp2,
77: fa_deprn_periods dp3,
78: fa_book_controls bc
79: where dp.book_type_code =c_book_type_code

Line 76: fa_deprn_periods dp2,

72: Select dp.period_name,
73: bc.last_deprn_run_date,
74: bc.deprn_calendar
75: from fa_deprn_periods dp,
76: fa_deprn_periods dp2,
77: fa_deprn_periods dp3,
78: fa_book_controls bc
79: where dp.book_type_code =c_book_type_code
80: and dp.period_close_date is null

Line 77: fa_deprn_periods dp3,

73: bc.last_deprn_run_date,
74: bc.deprn_calendar
75: from fa_deprn_periods dp,
76: fa_deprn_periods dp2,
77: fa_deprn_periods dp3,
78: fa_book_controls bc
79: where dp.book_type_code =c_book_type_code
80: and dp.period_close_date is null
81: and dp2.book_type_code(+) = bc.distribution_source_book