[Home] [Help]
61: cp.end_Date , p_period_counter, fy.fiscal_year
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
113: fy.fiscal_year
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
161: fy.fiscal_year
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
705: END IF;
706:
707: SELECT ct.calendar_type , ct.fiscal_year_name
708: INTO l_calendar , l_fiscal_year_name
709: FROM fa_Calendar_types ct , fa_book_controls bc
710: WHERE ct.calendar_type = bc.deprn_calendar
711: AND bc.book_type_Code = P_book_type_Code ;
712:
713: SELECT fy.start_Date
832: fy.fiscal_year
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