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.HRI_OLTP_DISC_WRKFRC dependencies on PER_PERIODS_OF_SERVICE

Line 1269: FROM per_periods_of_service

1265:
1266: CURSOR get_pps_months_cur IS
1267: SELECT sum(months_between(least(nvl(actual_termination_date + 1,
1268: p_effective_date + 1), p_effective_date + 1), date_start)) total_months
1269: FROM per_periods_of_service
1270: WHERE person_id = p_person_id
1271: AND date_start <= p_effective_date
1272: AND period_of_service_id <= p_period_of_service_id;
1273:

Line 1308: FROM per_periods_of_service

1304: CURSOR get_pps_years_cur IS
1305: SELECT sum(months_between
1306: (least(nvl(actual_termination_date + 1, p_effective_date + 1),
1307: p_effective_date + 1), date_start)) / 12 total_years
1308: FROM per_periods_of_service
1309: WHERE person_id = p_person_id
1310: AND date_start <= p_effective_date
1311: AND period_of_service_id <= p_period_of_service_id;
1312: