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.PO_MASS_UPDATE_REQ_PVT dependencies on PER_ALL_PEOPLE_F

Line 1392: FROM per_all_people_f pap,

1388: SELECT pap.email_address,
1389: hr_general.get_work_phone(pap.person_id),
1390: hr_general.get_phone_number(pap.person_id, 'WF')
1391: INTO l_requester_email, l_requester_phone, l_requester_fax
1392: FROM per_all_people_f pap,
1393: per_all_assignments_f asgn
1394: WHERE pap.person_id = p_new_personid
1395: AND asgn.person_id = pap.person_id
1396: AND asgn.primary_flag = 'Y'

Line 1400: FROM per_all_people_f pap2

1396: AND asgn.primary_flag = 'Y'
1397: AND asgn.assignment_type IN ('E','C')
1398: AND pap.effective_end_date in
1399: ( SELECT min(pap2.effective_end_date)
1400: FROM per_all_people_f pap2
1401: WHERE pap2.person_id = pap.person_id
1402: AND TRUNC(sysdate) <= pap2.effective_end_date )
1403: AND asgn.effective_end_date in
1404: ( select min(asgn2.effective_end_date)