26: /* replaced the above code with this code */
27: if p_effective_date_t is null then
28: p_effective_date_t := sysdate;
29: end if;
30: c_business_group_name := hr_reports.get_business_group(p_business_group_id);
31: if p_payroll_id is not null then
32: --c_payroll_name := hr_reports.get_payroll_name(p_effective_date,p_payroll_id);
33: c_payroll_name := hr_reports.get_payroll_name(p_effective_date_t,p_payroll_id);
34: else
28: p_effective_date_t := sysdate;
29: end if;
30: c_business_group_name := hr_reports.get_business_group(p_business_group_id);
31: if p_payroll_id is not null then
32: --c_payroll_name := hr_reports.get_payroll_name(p_effective_date,p_payroll_id);
33: c_payroll_name := hr_reports.get_payroll_name(p_effective_date_t,p_payroll_id);
34: else
35: c_payroll_name:= 'All Payrolls';
36: end if;
29: end if;
30: c_business_group_name := hr_reports.get_business_group(p_business_group_id);
31: if p_payroll_id is not null then
32: --c_payroll_name := hr_reports.get_payroll_name(p_effective_date,p_payroll_id);
33: c_payroll_name := hr_reports.get_payroll_name(p_effective_date_t,p_payroll_id);
34: else
35: c_payroll_name:= 'All Payrolls';
36: end if;
37: