[Home] [Help]
62: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
63: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
64: FROM fa_fiscal_year fy ,
65: fa_calendar_types ct ,
66: fa_calendar_periods cp,
67: fa_book_controls bc
68: WHERE ct.fiscal_year_name = fy.fiscal_year_name
69: AND bc.book_type_code = P_book_type_code
70: AND ct.calendar_type = bc.deprn_Calendar
114: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
115: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
116: FROM fa_fiscal_year fy ,
117: fa_calendar_types ct ,
118: fa_calendar_periods cp ,
119: fa_book_controls bc
120: WHERE ct.fiscal_year_name = fy.fiscal_year_name
121: AND bc.book_type_code = P_book_type_code
122: AND ct.calendar_type = bc.deprn_Calendar
162: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
163: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
164: FROM fa_fiscal_year fy ,
165: fa_calendar_types ct ,
166: fa_calendar_periods cp ,
167: fa_book_controls bc
168: WHERE ct.fiscal_year_name = fy.fiscal_year_name
169: AND bc.book_type_code = P_book_type_code
170: AND ct.calendar_type = bc.deprn_Calendar
833: INTO l_prd_rec.period_num, l_prd_rec.period_name, l_prd_rec.period_start_date,
834: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
835: FROM fa_fiscal_year fy ,
836: fa_calendar_types ct ,
837: fa_calendar_periods cp ,
838: fa_book_controls bc
839: WHERE ct.fiscal_year_name = fy.fiscal_year_name
840: AND bc.book_type_code = X_book_type_code
841: AND ct.calendar_type = bc.deprn_Calendar
938: where book_type_code = X_book_type_code;
939:
940: Cursor start_end_dat(cp_dep_cal varchar2) is
941: select start_date , end_date
942: from fa_calendar_periods
943: where period_name = X_Period_Name
944: and calendar_type = cp_dep_cal;
945:
946: Cursor c_price_index_value(cp_cal_prc_idx_id number,cp_start_date date,cp_end_date date) IS