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 812: * multiple records for the person in per_all_people_f table.

808: /** bgu, Apr. 08, 1999
809: * (1) Even the approver is no longer with the org, still need to retieve his/her
810: * Full Name.
811: * (2) Suppose a person has multiple employing history with the org, there're
812: * multiple records for the person in per_all_people_f table.
813: */
814: select distinct full_name
815: into value
816: from per_all_people_f hre

Line 816: from per_all_people_f hre

812: * multiple records for the person in per_all_people_f table.
813: */
814: select distinct full_name
815: into value
816: from per_all_people_f hre
817: where hre.person_id = approver_id
818: and trunc(sysdate) BETWEEN effective_start_date
819: and effective_end_date;
820:

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

834: /** bgu, Apr. 08, 1999
835: * (1) Even the approver is no longer with the org, still need to retieve his/her
836: * Full Name.
837: * (2) Suppose a person has multiple employing history with the org, there're
838: * multiple records for the person in per_all_people_f table.
839: */
840: select distinct email_address
841: into value
842: from per_all_people_f hre

Line 842: from per_all_people_f hre

838: * multiple records for the person in per_all_people_f table.
839: */
840: select distinct email_address
841: into value
842: from per_all_people_f hre
843: where hre.person_id = approver_id
844: and trunc(sysdate) BETWEEN effective_start_date
845: and effective_end_date;
846:

Line 1036: per_all_people_f hre

1032: begin
1033: select distinct pb.name
1034: into value
1035: from PER_BUSINESS_GROUPS_PERF pb,
1036: per_all_people_f hre
1037: where hre.person_id = approver_id
1038: and hre.business_group_id=pb.business_group_id
1039: and trunc(sysdate) BETWEEN effective_start_date
1040: and effective_end_date;

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

1606: RETURN;
1607: END IF;
1608:
1609: SELECT pap.full_name, pap.email_address, (select ph.phone_number from per_phones ph where
1610: ph.parent_table(+) = 'PER_ALL_PEOPLE_F' AND
1611: ph.parent_id (+) = fnd.employee_id AND
1612: ph.phone_type(+) = 'W1' AND
1613: trunc(SYSDATE) BETWEEN nvl(PH.DATE_FROM, trunc(SYSDATE)) AND
1614: nvl(PH.DATE_TO, trunc(SYSDATE)) ) phone_number,

Line 1623: per_all_people_f pap

1619: wf_notification_attributes wna,
1620: wf_user_roles wlur,
1621: fnd_user fnd,
1622: po_requisition_headers_all prh,
1623: per_all_people_f pap
1624: WHERE
1625: prh.requisition_header_id = req_header_id AND
1626: wlur.user_name = fnd.user_name AND
1627: pap.person_id = fnd.employee_id AND

Line 1727: PER_ALL_PEOPLE_F PAPF,

1723: order_cancel_flag ,
1724: order_hold_flag ,
1725: buyer
1726: FROM PO_CLMREQ_LINE_AWD_REFS_V ph,
1727: PER_ALL_PEOPLE_F PAPF,
1728: HR_ALL_ORGANIZATION_UNITS_VL HOU
1729: WHERE
1730: ph.requisition_line_id = p_req_line_id
1731: AND PH.ORG_ID = HOU.ORGANIZATION_ID (+)