[Home] [Help]
136: l_previous_end_date DATE;
137:
138: -- Archiving the data , as this will fire once
139: CURSOR csr_legal_employer_details (
140: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
141: ) IS
142: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
143: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
144: WHERE o1.business_group_id = g_business_group_id
139: CURSOR csr_legal_employer_details (
140: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
141: ) IS
142: SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
143: FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
144: WHERE o1.business_group_id = g_business_group_id
145: AND hoi1.organization_id = o1.organization_id
146: AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
147: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
156: l_prev_avg_men_count NUMBER;
157: l_prev_avg_women_count NUMBER;
158:
159: FUNCTION get_emp_count (
160: p_legal_employer_id hr_organization_information.organization_id%TYPE,
161: p_gender_type per_all_people_f.sex%TYPE,
162: p_start_date DATE,
163: p_end_date DATE
164: )
167: l_end_count NUMBER := 0;
168: l_average_count NUMBER := 0;
169:
170: CURSOR csr_get_employee_count (
171: p_legal_employer_id hr_organization_information.organization_id%TYPE,
172: p_gender_type per_all_people_f.sex%TYPE,
173: p_effective_date DATE
174: ) IS
175: SELECT count (*)
176: FROM per_all_people_f papf,
177: per_all_assignments_f paaf,
178: hr_soft_coding_keyflex hsc,
179: per_assignment_status_types past,
180: hr_organization_information hoi,
181: per_person_types ppt
182: WHERE paaf.person_id = papf.person_id
183: AND paaf.business_group_id = papf.business_group_id
184: AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id