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.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_PERIODS_OF_PLACEMENT

Line 303: FROM per_all_people_f ppf, per_periods_of_placement ppp

299: SELECT 'Y'
300: FROM DUAL
301: WHERE EXISTS (
302: SELECT 'x'
303: FROM per_all_people_f ppf, per_periods_of_placement ppp
304: WHERE ppf.person_id = p_supervisor_id
305: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
306: AND ppf.person_id = ppp.person_id
307: AND TRUNC (SYSDATE) BETWEEN ppp.date_start AND NVL (ppp.actual_termination_date, TRUNC (SYSDATE)));

Line 316: FROM per_all_assignments_f paaf, per_periods_of_placement ppp

312: SELECT 'Y'
313: FROM DUAL
314: WHERE EXISTS (
315: SELECT 'x'
316: FROM per_all_assignments_f paaf, per_periods_of_placement ppp
317: WHERE paaf.assignment_id = p_supervisor_asg_id
318: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
319: AND paaf.person_id = ppp.person_id
320: AND paaf.period_of_placement_date_start = ppp.date_start