[Home] [Help]
60: SELECT cp.period_num, cp.period_name, cp.start_date ,
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
112: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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
160: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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
711: AND bc.book_type_Code = P_book_type_Code ;
712:
713: SELECT fy.start_Date
714: INTO l_fy_start_date
715: FROM fa_fiscal_year fy
716: WHERE fy.fiscal_year_name = l_fiscal_year_name
717: AND fy.fiscal_year = l_prd_tab.fiscal_year ;
718:
719: -- bug 2452521, start (1)
831: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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