DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_CALENDAR_PERIODS

Line 40: from fa_calendar_periods cp,

36: /* this cursor displays life_end_date incorrectly ( to the last period_date defined )
37: if the life fell beyond existing calendar periods
38: CURSOR C IS
39: select max(cp.end_date)
40: from fa_calendar_periods cp,
41: fa_calendar_types ct,
42: fa_book_controls bc
43: where bc.book_type_code = X_book_type_code and
44: bc.date_ineffective is null and

Line 84: from fa_calendar_periods cp,

80: (decode (bc.deprn_allocation_code,'E',
81: 1/ct.number_per_fiscal_year,
82: (cp.end_date + 1 - cp.start_date) /
83: (fy.end_date + 1 - fy.start_date))),0) * 12, 0)
84: from fa_calendar_periods cp,
85: fa_calendar_types ct,
86: fa_book_controls bc,
87: fa_fiscal_year fy
88: where bc.book_type_code = X_book_type_code and