DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_CALENDAR_PERIODS

Line 42: from fa_calendar_periods cp,

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

Line 86: from fa_calendar_periods cp,

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