DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on HR_GENERAL

Line 1389: hr_general.get_work_phone(pap.person_id),

1385: IF (p_document_type IS NULL OR p_document_type IN ('PURCHASE','INTERNAL','ALL')) THEN --
1386: -- Bug 14153104 start
1387: BEGIN
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

Line 1390: hr_general.get_phone_number(pap.person_id, 'WF')

1386: -- Bug 14153104 start
1387: BEGIN
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