25: P_DATE_FROM_T := to_char(P_DATE_FROM,'dd-mon-yyyy');
26: P_DATE_TO_T := to_char(P_DATE_TO,'dd-mon-yyyy');
27:
28: c_business_group_name :=
29: hr_reports.get_business_group(p_business_group_id);
30:
31: if p_org_structure_version_id is not null then
32: hr_reports.get_organization_hierarchy
33: (null
28: c_business_group_name :=
29: hr_reports.get_business_group(p_business_group_id);
30:
31: if p_org_structure_version_id is not null then
32: hr_reports.get_organization_hierarchy
33: (null
34: ,p_org_structure_version_id
35: ,l_organization_structure_desc
36: ,l_org_version_desc
44: end if;
45:
46: if p_parent_organization_id is not null then
47:
48: hr_reports.get_organization
49: (p_parent_organization_id
50: ,l_organization_desc
51: ,l_organization_type);
52:
56: end if;
57:
58: if p_payroll_id is not null then
59: c_payroll_name :=
60: hr_reports.get_payroll_name(p_session_date,p_payroll_id);
61:
62: p_payroll_matching :=
63: ' and paf.payroll_id +0 = '|| to_char(p_payroll_id);
64:
176:
177: end if;
178:
179: if p_payroll_period_id is not null then
180: hr_reports.get_time_period(p_payroll_period_id,
181: l_payroll_period,
182: l_payroll_period_start_date,
183: l_payroll_period_end_date);
184: