DBA Data[Home] [Help]

APPS.EAM_CAP_MAIN_COST_PVT dependencies on FA_BOOK_CONTROLS

Line 77: fa_book_controls FAC

73:
74: CURSOR c_dep_date (c_calendar_type in varchar, c_book_type_code IN varchar, c_period_name in varchar) IS
75: SELECT END_DATE
76: FROM FA_CALENDAR_PERIODS FAP,
77: fa_book_controls FAC
78: WHERE FAP.calendar_type=c_calendar_type
79: AND FAC.BOOk_TYPE_CODE =c_book_type_code
80: AND FAP.PERIOD_NAME=c_period_name;
81:

Line 89: fa_book_controls bc

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
93: and dp2.period_counter(+) = bc.last_mass_copy_period_counter