1101:
1102: begin
1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1102: begin
1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);
1103:
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);
1111: c_report_year3 := substr(c_report_year,3,1);
1104: l_business_group_name := hr_reports.get_business_group(p_business_group_id);
1105: P_DATE_END1 := fnd_date.canonical_to_date(P_DATE_END);
1106: c_report_year := to_char(fnd_date.canonical_to_date(P_DATE_END),'RRRR');
1107: c_report_month := to_char(fnd_date.canonical_to_date(P_DATE_END),'MM');
1108: c_report_day := to_char(fnd_date.canonical_to_date(P_DATE_END),'DD');
1109: c_report_year1 := substr(c_report_year,1,1);
1110: c_report_year2 := substr(c_report_year,2,1);
1111: c_report_year3 := substr(c_report_year,3,1);
1112: c_report_year4 := substr(c_report_year,4,1);