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 310: FROM hr_all_organization_units

306: AND ass.job_id = job.job_id
307: AND ass.assignment_type = 'E'
308: AND ass.organization_id IN (
309: SELECT organization_id
310: FROM hr_all_organization_units
311: WHERE business_group_id = p_business_group_id)
312: GROUP BY
313: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
314: 'FR', 'A. FULL-TIME STAFF') ,

Line 377: FROM hr_all_organization_units

373: AND ass.job_id = job.job_id
374: AND ass.assignment_type = 'E'
375: AND ass.organization_id IN (
376: SELECT organization_id
377: FROM hr_all_organization_units
378: WHERE business_group_id = p_business_group_id)
379: GROUP BY
380: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
381: 'FT','B. PART-TIME STAFF',

Line 444: FROM hr_all_organization_units

440: AND ass.primary_flag = 'Y'
441: 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
442: AND ass.organization_id IN (
443: SELECT organization_id
444: FROM hr_all_organization_units
445: WHERE business_group_id = p_business_group_id )
446: GROUP BY DECODE(job.job_information1,
447: '1','23.0/A/M', '2','24.PRIN/ASST.PR',
448: '3','24.PRIN/ASST.PR', '4','24.PRIN/ASST.PR',

Line 502: FROM hr_all_organization_units

498: AND ass.job_id = job.job_id
499: AND ass.assignment_type = 'E'
500: AND ass.organization_id IN (
501: SELECT organization_id
502: FROM hr_all_organization_units
503: WHERE business_group_id = p_business_group_id)
504: 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
505: 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;
506:

Line 554: FROM hr_all_organization_units

550: AND ass.job_id = job.job_id
551: AND ass.assignment_type = 'E'
552: AND ass.organization_id IN (
553: SELECT organization_id
554: FROM hr_all_organization_units
555: WHERE business_group_id = p_business_group_id)
556: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
557: 'FT','B. PART-TIME STAFF',
558: 'PR','B. PART-TIME STAFF',

Line 620: FROM hr_all_organization_units

616: AND ass.primary_flag = 'Y'
617: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
618: AND ass.organization_id IN (
619: SELECT organization_id
620: FROM hr_all_organization_units
621: WHERE business_group_id = p_business_group_id )
622: and 'C. NEW HIRES (JULY THRU SEPT. '||p_report_year||')' = p_employment_category
623: and DECODE(job.job_information1,
624: '1','23.0/A/M', '2','24.PRIN/ASST.PR',

Line 670: FROM hr_all_organization_units

666: AND p_report_date between peo.effective_start_date and peo.effective_end_date
667: AND hou.business_group_id = p_business_group_id
668: UNION
669: SELECT location_id
670: FROM hr_all_organization_units
671: WHERE business_group_id = p_business_group_id
672: AND NVL(date_to,p_report_date + 1) >= p_report_date );
673: l_count_annexes NUMBER := 0;
674: