APPS.POR_VIEW_REQS_PKG dependencies on PER_PHONES

Line 25: per_phones ph,

21: wf_notifications wn,
22: wf_user_roles wlur,
23: fnd_user fnd,
24: po_requisition_headers_all prh,
25: per_phones ph,
26: per_all_people_f pap
27: WHERE
28: prh.requisition_header_id = 140331 AND
29: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND

Line 1486: SELECT pap.full_name, pap.email_address, (select ph.phone_number from per_phones ph where

1482: IF (nvl(l_approver_id, -1) = -1) THEN
1483: RETURN;
1484: END IF;
1485:
1486: SELECT pap.full_name, pap.email_address, (select ph.phone_number from per_phones ph where
1487: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND
1488: ph.parent_id (+) = fnd.employee_id AND
1489: ph.phone_type(+) = 'W1' AND
1490: trunc(SYSDATE) BETWEEN nvl(PH.DATE_FROM, trunc(SYSDATE)) AND