[Home] [Help]
37: SELECT cp.period_num, cp.period_name, cp.start_date ,
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
89: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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
137: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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
681: AND bc.book_type_Code = P_book_type_Code ;
682:
683: SELECT fy.start_Date
684: INTO l_fy_start_date
685: FROM fa_fiscal_year fy
686: WHERE fy.fiscal_year_name = l_fiscal_year_name
687: AND fy.fiscal_year = l_prd_tab.fiscal_year ;
688:
689: -- bug 2452521, start (1)
801: ((fy.fiscal_year*ct.number_per_fiscal_year)+cp.period_num) p_period_counter,
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