eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_HCIA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 161: p_gender_type per_all_people_f.sex%TYPE,

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: )
165: RETURN NUMBER IS

Line 172: p_gender_type per_all_people_f.sex%TYPE,

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,

Line 176: FROM per_all_people_f papf,

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,