[Home] [Help]
38: cp.end_Date , p_period_counter, fy.fiscal_year
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
90: fy.fiscal_year
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
138: fy.fiscal_year
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
675: END IF;
676:
677: SELECT ct.calendar_type , ct.fiscal_year_name
678: INTO l_calendar , l_fiscal_year_name
679: FROM fa_Calendar_types ct , fa_book_controls bc
680: WHERE ct.calendar_type = bc.deprn_calendar
681: AND bc.book_type_Code = P_book_type_Code ;
682:
683: SELECT fy.start_Date
802: fy.fiscal_year
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