39: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
40: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
41: FROM fa_fiscal_year fy ,
42: fa_calendar_types ct ,
43: fa_calendar_periods cp,
44: fa_book_controls bc
45: WHERE ct.fiscal_year_name = fy.fiscal_year_name
46: AND bc.book_type_code = P_book_type_code
47: AND ct.calendar_type = bc.deprn_Calendar
91: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
92: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
93: FROM fa_fiscal_year fy ,
94: fa_calendar_types ct ,
95: fa_calendar_periods cp ,
96: fa_book_controls bc
97: WHERE ct.fiscal_year_name = fy.fiscal_year_name
98: AND bc.book_type_code = P_book_type_code
99: AND ct.calendar_type = bc.deprn_Calendar
139: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
140: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
141: FROM fa_fiscal_year fy ,
142: fa_calendar_types ct ,
143: fa_calendar_periods cp ,
144: fa_book_controls bc
145: WHERE ct.fiscal_year_name = fy.fiscal_year_name
146: AND bc.book_type_code = P_book_type_code
147: AND ct.calendar_type = bc.deprn_Calendar
803: INTO l_prd_rec.period_num, l_prd_rec.period_name, l_prd_rec.period_start_date,
804: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
805: FROM fa_fiscal_year fy ,
806: fa_calendar_types ct ,
807: fa_calendar_periods cp ,
808: fa_book_controls bc
809: WHERE ct.fiscal_year_name = fy.fiscal_year_name
810: AND bc.book_type_code = X_book_type_code
811: AND ct.calendar_type = bc.deprn_Calendar
908: where book_type_code = X_book_type_code;
909:
910: Cursor start_end_dat(cp_dep_cal varchar2) is
911: select start_date , end_date
912: from fa_calendar_periods
913: where period_name = X_Period_Name
914: and calendar_type = cp_dep_cal;
915:
916: Cursor c_price_index_value(cp_cal_prc_idx_id number,cp_start_date date,cp_end_date date) IS