APPS.PER_US_EEO5_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 226: FROM hr_all_organization_units

222: --Step 1
223: CURSOR csr_bg_details(p_business_group_id IN NUMBER) IS
224: SELECT name bg_name,
225: location_id
226: FROM hr_all_organization_units
227: WHERE business_group_id = p_business_group_id
228: AND organization_id = p_business_group_id;
229:
230: l_bg_name VARCHAR2(200);

Line 324: FROM hr_all_organization_units

320: AND ass.job_id = job.job_id
321: AND ass.assignment_type = 'E'
322: AND ass.organization_id IN (
323: SELECT organization_id
324: FROM hr_all_organization_units
325: WHERE business_group_id = p_business_group_id)
326: GROUP BY
327: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
328: 'FR', 'A. FULL-TIME STAFF') ,

Line 405: FROM hr_all_organization_units

401: AND ass.job_id = job.job_id
402: AND ass.assignment_type = 'E'
403: AND ass.organization_id IN (
404: SELECT organization_id
405: FROM hr_all_organization_units
406: WHERE business_group_id = p_business_group_id)
407: GROUP BY
408: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
409: 'FT','B. PART-TIME STAFF',

Line 488: FROM hr_all_organization_units

484: AND ass.primary_flag = 'Y'
485: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) = 'FR' -- Only full-time regular no temporaries
486: AND ass.organization_id IN (
487: SELECT organization_id
488: FROM hr_all_organization_units
489: WHERE business_group_id = p_business_group_id )
490: GROUP BY DECODE(job.job_information1,
491: '1','23.0/A/M', '2','24.PRIN/ASST.PR',
492: '3','24.PRIN/ASST.PR', '4','24.PRIN/ASST.PR',

Line 548: FROM hr_all_organization_units

544: AND ass.job_id = job.job_id
545: AND ass.assignment_type = 'E'
546: AND ass.organization_id IN (
547: SELECT organization_id
548: FROM hr_all_organization_units
549: WHERE business_group_id = p_business_group_id)
550: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),'FR', 'A. FULL-TIME STAFF') = p_employment_category
551: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) = p_job_category_name;
552: Commented for bug#11736960 ends */

Line 602: FROM hr_all_organization_units

598: AND ass.job_id = job.job_id
599: AND ass.assignment_type = 'E'
600: AND ass.organization_id IN (
601: SELECT organization_id
602: FROM hr_all_organization_units
603: WHERE business_group_id = p_business_group_id)
604: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
605: 'FT','B. PART-TIME STAFF',
606: 'PR','B. PART-TIME STAFF',

Line 672: FROM hr_all_organization_units

668: AND ass.primary_flag = 'Y'
669: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
670: AND ass.organization_id IN (
671: SELECT organization_id
672: FROM hr_all_organization_units
673: WHERE business_group_id = p_business_group_id )
674: and 'C. NEW HIRES (JULY THRU SEPT. '||p_report_year||')' = p_employment_category
675: and DECODE(job.job_information1,
676: '1','23.0/A/M', '2','24.PRIN/ASST.PR',

Line 722: FROM hr_all_organization_units

718: AND p_report_date between peo.effective_start_date and peo.effective_end_date
719: AND hou.business_group_id = p_business_group_id
720: UNION
721: SELECT location_id
722: FROM hr_all_organization_units
723: WHERE business_group_id = p_business_group_id
724: AND NVL(date_to,p_report_date + 1) >= p_report_date );
725: l_count_annexes NUMBER := 0;
726: