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.PER_US_EEO5_PKG dependencies on PQH_EMPLOYMENT_CATEGORY

Line 275: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

271: ,p_pr IN VARCHAR2
272: ,p_pt IN VARCHAR2
273: ,p_report_date IN DATE
274: ,p_report_year IN NUMBER) IS
275: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
276: 'FR', 'A. FULL-TIME STAFF') employment_category,
277: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
278: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) job_category_name,
279: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,

Line 277: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

273: ,p_report_date IN DATE
274: ,p_report_year IN NUMBER) IS
275: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
276: 'FR', 'A. FULL-TIME STAFF') employment_category,
277: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
278: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) job_category_name,
279: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
280: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
281: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

Line 298: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')

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')
299: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
300: AND job.job_information_category = 'US'
301: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
302: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date

Line 313: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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') ,
315: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
316: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning)
317: ORDER BY 1,2;

Line 315: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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') ,
315: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
316: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning)
317: ORDER BY 1,2;
318:
319:

Line 328: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

324: ,p_pr IN VARCHAR2
325: ,p_pt IN VARCHAR2
326: ,p_report_date IN DATE
327: ,p_report_year IN NUMBER) IS
328: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
329: 'FT','B. PART-TIME STAFF',
330: 'PR','B. PART-TIME STAFF',
331: 'PT','B. PART-TIME STAFF') employment_category,
332: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

Line 332: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

328: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
329: 'FT','B. PART-TIME STAFF',
330: 'PR','B. PART-TIME STAFF',
331: 'PT','B. PART-TIME STAFF') employment_category,
332: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
333: 'PR',DECODE(job.job_information1,
334: '2','20.PROF. INSTR.',
335: '3','20.PROF. INSTR.',
336: '4','20.PROF. INSTR.',

Line 365: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')

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')
366: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
367: AND job.job_information_category = 'US'
368: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
369: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date

Line 380: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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',
382: 'PR','B. PART-TIME STAFF',
383: 'PT','B. PART-TIME STAFF') ,
384: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

Line 384: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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',
382: 'PR','B. PART-TIME STAFF',
383: 'PT','B. PART-TIME STAFF') ,
384: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
385: 'PR', DECODE(job.job_information1,
386: '2','20.PROF. INSTR.', '3','20.PROF. INSTR.',
387: '4','20.PROF. INSTR.', '5','20.PROF. INSTR.',
388: '6','20.PROF. INSTR.', '7','20.PROF. INSTR.',

Line 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

437: FROM per_periods_of_service
438: WHERE period_of_service_id = ass.period_of_service_id)
439: BETWEEN ADD_MONTHS(p_report_date,-3) +1 AND p_report_date
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 )

Line 495: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')

491: AND job.job_information_category = 'US'
492: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
493: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date
494: AND ass.primary_flag = 'Y'
495: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
496: AND ass.assignment_status_type_id = ast.assignment_status_type_id
497: AND ast.per_system_status <> 'TERM_ASSIGN'
498: AND ass.job_id = job.job_id
499: AND ass.assignment_type = 'E'

Line 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

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:
507:
508:

Line 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;

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:
507:
508:
509: --Step 4

Line 547: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')

543: AND job.job_information_category = 'US'
544: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
545: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date
546: AND ass.primary_flag = 'Y'
547: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')
548: AND ass.assignment_status_type_id = ast.assignment_status_type_id
549: AND ast.per_system_status <> 'TERM_ASSIGN'
550: AND ass.job_id = job.job_id
551: AND ass.assignment_type = 'E'

Line 556: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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',
559: 'PT','B. PART-TIME STAFF') = p_employment_category
560: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

Line 560: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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',
559: 'PT','B. PART-TIME STAFF') = p_employment_category
560: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
561: 'PR',DECODE(job.job_information1,
562: '2','20.PROF. INSTR.',
563: '3','20.PROF. INSTR.',
564: '4','20.PROF. INSTR.',

Line 617: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')

613: FROM per_periods_of_service
614: WHERE period_of_service_id = ass.period_of_service_id)
615: BETWEEN ADD_MONTHS(p_report_date,-3) +1 AND p_report_date
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 )

Line 931: pqh_employment_category.fetch_empl_categories(p_business_group_id

927: /* Resetting l_xml_string */
928: l_xml_string := '';
929: l_xml_string := l_xml_string||'';
930:
931: pqh_employment_category.fetch_empl_categories(p_business_group_id
932: ,l_fr
933: ,l_ft
934: ,l_pr
935: ,l_pt);