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: -- Added for bug#11736960

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: -- Added for bug#11736960
280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

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

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')
313: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
314: AND job.job_information_category = 'US'
315: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
316: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date

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

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

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

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

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

338: ,p_pr IN VARCHAR2
339: ,p_pt IN VARCHAR2
340: ,p_report_date IN DATE
341: ,p_report_year IN NUMBER) IS
342: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
343: 'FT','B. PART-TIME STAFF',
344: 'PR','B. PART-TIME STAFF',
345: 'PT','B. PART-TIME STAFF') employment_category,
346: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),

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

342: SELECT DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
343: 'FT','B. PART-TIME STAFF',
344: 'PR','B. PART-TIME STAFF',
345: 'PT','B. PART-TIME STAFF') employment_category,
346: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
347: 'PR',DECODE(job.job_information1,
348: '2','20.PROF. INSTR.',
349: '3','20.PROF. INSTR.',
350: '4','20.PROF. INSTR.',

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

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')
394: AND hl.lookup_type = 'US_EEO5_JOB_CATEGORIES'
395: AND job.job_information_category = 'US'
396: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
397: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date

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

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

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

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',
410: 'PR','B. PART-TIME STAFF',
411: 'PT','B. PART-TIME STAFF') ,
412: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
413: 'PR', DECODE(job.job_information1,
414: '2','20.PROF. INSTR.', '3','20.PROF. INSTR.',
415: '4','20.PROF. INSTR.', '5','20.PROF. INSTR.',
416: '6','20.PROF. INSTR.', '7','20.PROF. INSTR.',

Line 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

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

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

537: AND job.job_information_category = 'US'
538: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
539: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date
540: AND ass.primary_flag = 'Y'
541: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('FR')
542: AND ass.assignment_status_type_id = ast.assignment_status_type_id
543: AND ast.per_system_status <> 'TERM_ASSIGN'
544: AND ass.job_id = job.job_id
545: AND ass.assignment_type = 'E'

Line 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

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 */
553:
554:

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

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 */
553:
554:
555: --Step 4

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

591: AND job.job_information_category = 'US'
592: AND p_report_date BETWEEN peo.effective_start_date AND peo.effective_end_date
593: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date
594: AND ass.primary_flag = 'Y'
595: AND pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt) IN ('PR')
596: AND ass.assignment_status_type_id = ast.assignment_status_type_id
597: AND ast.per_system_status <> 'TERM_ASSIGN'
598: AND ass.job_id = job.job_id
599: AND ass.assignment_type = 'E'

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

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

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

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',
607: 'PT','B. PART-TIME STAFF') = p_employment_category
608: AND DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
609: 'PR',DECODE(job.job_information1,
610: '2','20.PROF. INSTR.',
611: '3','20.PROF. INSTR.',
612: '4','20.PROF. INSTR.',

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

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

Line 987: pqh_employment_category.fetch_empl_categories(p_business_group_id

983: /* Resetting l_xml_string */
984: l_xml_string := '';
985: l_xml_string := l_xml_string||'';
986:
987: pqh_employment_category.fetch_empl_categories(p_business_group_id
988: ,l_fr
989: ,l_ft
990: ,l_pr
991: ,l_pt);