APPS.POR_VIEW_REQS_PKG dependencies on PER_ALL_PEOPLE_F

Line 26: per_all_people_f pap

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
30: ph.parent_id (+) = fnd.employee_id AND

Line 29: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND

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
30: ph.parent_id (+) = fnd.employee_id AND
31: ph.phone_type(+) = 'W1' AND
32: wlur.user_name = fnd.user_name AND
33: pap.person_id = fnd.employee_id AND

Line 74: per_all_people_f hre,

70: else
71: select full_name
72: into value
73: from
74: per_all_people_f hre,
75: po_requisition_lines_all prl
76: where
77: sysdate between hre.effective_start_date AND hre.effective_end_date AND
78: prl.to_person_id = hre.person_id AND

Line 734: * multiple records for the person in per_all_people_f table.

730: /** bgu, Apr. 08, 1999
731: * (1) Even the approver is no longer with the org, still need to retieve his/her
732: * Full Name.
733: * (2) Suppose a person has multiple employing history with the org, there're
734: * multiple records for the person in per_all_people_f table.
735: */
736: select distinct full_name
737: into value
738: from per_all_people_f hre

Line 738: from per_all_people_f hre

734: * multiple records for the person in per_all_people_f table.
735: */
736: select distinct full_name
737: into value
738: from per_all_people_f hre
739: where hre.person_id = approver_id
740: and trunc(sysdate) BETWEEN effective_start_date
741: and effective_end_date;
742:

Line 760: * multiple records for the person in per_all_people_f table.

756: /** bgu, Apr. 08, 1999
757: * (1) Even the approver is no longer with the org, still need to retieve his/her
758: * Full Name.
759: * (2) Suppose a person has multiple employing history with the org, there're
760: * multiple records for the person in per_all_people_f table.
761: */
762: select distinct email_address
763: into value
764: from per_all_people_f hre

Line 764: from per_all_people_f hre

760: * multiple records for the person in per_all_people_f table.
761: */
762: select distinct email_address
763: into value
764: from per_all_people_f hre
765: where hre.person_id = approver_id
766: and trunc(sysdate) BETWEEN effective_start_date
767: and effective_end_date;
768:

Line 958: per_all_people_f hre

954: begin
955: select distinct pb.name
956: into value
957: from PER_BUSINESS_GROUPS_PERF pb,
958: per_all_people_f hre
959: where hre.person_id = approver_id
960: and hre.business_group_id=pb.business_group_id
961: and trunc(sysdate) BETWEEN effective_start_date
962: and effective_end_date;

Line 1487: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND

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
1491: nvl(PH.DATE_TO, trunc(SYSDATE)) ) phone_number,

Line 1500: per_all_people_f pap

1496: wf_notification_attributes wna,
1497: wf_user_roles wlur,
1498: fnd_user fnd,
1499: po_requisition_headers_all prh,
1500: per_all_people_f pap
1501: WHERE
1502: prh.requisition_header_id = req_header_id AND
1503: wlur.user_name = fnd.user_name AND
1504: pap.person_id = fnd.employee_id AND