108: bc.deprn_calendar
109: INTO h_pds_per_year,
110: h_p_pds_per_year,
111: h_period_type
112: FROM fa_calendar_types d_cal,
113: fa_calendar_types p_cal,
114: fa_book_controls bc
115: WHERE bc.deprn_calendar = d_cal.calendar_type
116: AND bc.prorate_calendar = p_cal.calendar_type
109: INTO h_pds_per_year,
110: h_p_pds_per_year,
111: h_period_type
112: FROM fa_calendar_types d_cal,
113: fa_calendar_types p_cal,
114: fa_book_controls bc
115: WHERE bc.deprn_calendar = d_cal.calendar_type
116: AND bc.prorate_calendar = p_cal.calendar_type
117: AND bc.book_type_code = h_book_type;