[Home] [Help]
290: FROM per_all_people_f peo,
291: per_all_assignments_f ass,
292: per_assignment_status_types ast,
293: per_jobs job,
294: hr_lookups hl
295: WHERE peo.person_id = ass.person_id
296: AND peo.current_employee_flag = 'Y'
297: AND hl.lookup_code = job.job_information1
298: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
357: FROM per_all_people_f peo,
358: per_all_assignments_f ass,
359: per_assignment_status_types ast,
360: per_jobs job,
361: hr_lookups hl
362: WHERE peo.person_id = ass.person_id
363: AND peo.current_employee_flag = 'Y'
364: AND hl.lookup_code = job.job_information1
365: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')
424: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
425: FROM per_all_people_f peo,
426: per_all_assignments_f ass,
427: per_jobs job,
428: hr_lookups hl
429: WHERE peo.person_id = ass.person_id
430: AND peo.current_employee_flag = 'Y'
431: AND hl.lookup_code = job.job_information1
432: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
477: FROM per_all_people_f peo,
478: per_all_assignments_f ass,
479: per_assignment_status_types ast,
480: per_jobs job,
481: hr_lookups hl,
482: per_people_extra_info pei
483: WHERE peo.person_id = ass.person_id
484: AND peo.per_information1 = '13'
485: AND peo.person_id = pei.person_id(+)
529: FROM per_all_people_f peo,
530: per_all_assignments_f ass,
531: per_assignment_status_types ast,
532: per_jobs job,
533: hr_lookups hl,
534: per_people_extra_info pei
535: WHERE peo.person_id = ass.person_id
536: AND peo.per_information1 = '13'
537: AND peo.person_id = pei.person_id(+)
595: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
596: FROM per_all_people_f peo,
597: per_all_assignments_f ass,
598: per_jobs job,
599: hr_lookups hl,
600: per_people_extra_info pei
601: WHERE peo.person_id = ass.person_id
602: AND peo.per_information1 = '13'
603: AND peo.person_id = pei.person_id(+)
720: ) IS
721:
722: CURSOR csr_lookup_code(p_counter IN NUMBER) IS
723: SELECT LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning
724: FROM hr_lookups hl
725: WHERE lookup_type = 'US_EEO5_JOB_CATEGORIES'
726: AND TO_NUMBER(lookup_code) = p_counter
727: AND application_id = 800;
728: l_job_category_name VARCHAR2(200);
731: BEGIN /*create_record*/
732:
733: FOR i IN p_start_code..p_end_code LOOP
734:
735: --Need to fetch the job_categroy_name from hr_lookups based on the variable 1.
736:
737: l_job_category_name := get_job_category_meaning(i);
738:
739: