APPS.PO_MASS_UPDATE_REQ_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1393: per_all_assignments_f asgn

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'
1397: AND asgn.assignment_type IN ('E','C')

Line 1405: from per_all_assignments_f asgn2

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)
1405: from per_all_assignments_f asgn2
1406: where asgn2.person_id = asgn.person_id
1407: and asgn2.primary_flag = 'Y'
1408: and asgn2.assignment_type IN ('E','C')
1409: and TRUNC(sysdate) <= asgn2.effective_end_date);