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 PER_PERIODS_OF_SERVICE

Line 437: FROM per_periods_of_service

433: AND job.job_information_category = 'US'
434: AND ass.job_id = job.job_id
435: AND ass.assignment_type = 'E'
436: AND (SELECT date_start
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

Line 613: FROM per_periods_of_service

609: AND job.job_information_category = 'US'
610: AND ass.job_id = job.job_id
611: AND ass.assignment_type = 'E'
612: AND (SELECT date_start
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')