[Home] [Help]
304: FROM per_all_people_f peo,
305: per_all_assignments_f ass,
306: per_assignment_status_types ast,
307: per_jobs job,
308: hr_lookups hl
309: WHERE peo.person_id = ass.person_id
310: AND peo.current_employee_flag = 'Y'
311: AND hl.lookup_code = job.job_information1
312: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
385: FROM per_all_people_f peo,
386: per_all_assignments_f ass,
387: per_assignment_status_types ast,
388: per_jobs job,
389: hr_lookups hl
390: WHERE peo.person_id = ass.person_id
391: AND peo.current_employee_flag = 'Y'
392: AND hl.lookup_code = job.job_information1
393: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')
466: Commented for bug#11736960 ends */
467: FROM per_all_people_f peo,
468: per_all_assignments_f ass,
469: per_jobs job,
470: hr_lookups hl
471: WHERE peo.person_id = ass.person_id
472: AND peo.current_employee_flag = 'Y'
473: AND hl.lookup_code = job.job_information1
474: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
523: FROM per_all_people_f peo,
524: per_all_assignments_f ass,
525: per_assignment_status_types ast,
526: per_jobs job,
527: hr_lookups hl,
528: per_people_extra_info pei
529: WHERE peo.person_id = ass.person_id
530: AND peo.per_information1 = '13'
531: AND peo.person_id = pei.person_id(+)
577: FROM per_all_people_f peo,
578: per_all_assignments_f ass,
579: per_assignment_status_types ast,
580: per_jobs job,
581: hr_lookups hl,
582: per_people_extra_info pei
583: WHERE peo.person_id = ass.person_id
584: AND peo.per_information1 = '13'
585: AND peo.person_id = pei.person_id(+)
645: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
646: FROM per_all_people_f peo,
647: per_all_assignments_f ass,
648: per_jobs job,
649: hr_lookups hl,
650: per_people_extra_info pei
651: WHERE peo.person_id = ass.person_id
652: AND peo.per_information1 = '13'
653: AND peo.person_id = pei.person_id(+)
776: ) IS
777:
778: CURSOR csr_lookup_code(p_counter IN NUMBER) IS
779: SELECT LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning
780: FROM hr_lookups hl
781: WHERE lookup_type = 'US_EEO5_JOB_CATEGORIES'
782: AND TO_NUMBER(lookup_code) = p_counter
783: AND application_id = 800;
784: l_job_category_name VARCHAR2(200);
787: BEGIN /*create_record*/
788:
789: FOR i IN p_start_code..p_end_code LOOP
790:
791: --Need to fetch the job_categroy_name from hr_lookups based on the variable 1.
792:
793: l_job_category_name := get_job_category_meaning(i);
794:
795: