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.

[Home] [Help]

APPS.PER_US_EEO5_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 481: FROM per_periods_of_service

477: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date -- Added for #9446839
478: AND ass.job_id = job.job_id
479: AND ass.assignment_type = 'E'
480: AND (SELECT date_start
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

Line 665: FROM per_periods_of_service

661: AND p_report_date BETWEEN ass.effective_start_date AND ass.effective_end_date -- Added for #9446839
662: AND ass.job_id = job.job_id
663: AND ass.assignment_type = 'E'
664: AND (SELECT date_start
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')