APPS.AP_WFAPPROVAL_PKG dependencies on PER_ALL_PEOPLE_F

Line 841: FROM per_all_people_f pap

837: --Bug 2785396 get requester name
838: IF l_requester_id IS NOT NULL THEN
839: SELECT full_name
840: INTO l_requester_name
841: FROM per_all_people_f pap
842: WHERE person_id = l_requester_id
843: and trunc(sysdate) between effective_start_date --bug3815124
844: and nvl(effective_end_date,trunc(sysdate));
845:

Line 1066: FROM per_all_people_f pap

1062:
1063: --commented for bug 13576488
1064: /* SELECT employee_number
1065: INTO l_return_val
1066: FROM per_all_people_f pap
1067: WHERE person_id = (SELECT ph.agent_id
1068: FROM ap_invoice_distributions_all aid,
1069: po_distributions_all pd,
1070: po_headers_all ph

Line 1085: PER_ALL_PEOPLE_F PAP

1081: into l_return_val FROM
1082: AP_INVOICE_DISTRIBUTIONS_ALL AID,
1083: PO_DISTRIBUTIONS_ALL PD,
1084: PO_HEADERS_ALL PH,
1085: PER_ALL_PEOPLE_F PAP
1086: WHERE AID.INVOICE_DISTRIBUTION_ID = p_dist_id
1087: AND PD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID
1088: AND PD.PO_HEADER_ID = PH.PO_HEADER_ID
1089: AND PD.CREATION_DATE >= PAP.EFFECTIVE_START_DATE

Line 1099: FROM per_all_people_f pap

1095:
1096: --commented for bug 13576488
1097: /* SELECT employee_number
1098: INTO l_return_val
1099: FROM per_all_people_f pap
1100: WHERE person_id = (SELECT pd.deliver_to_person_id
1101: FROM ap_invoice_distributions_all aid,
1102: po_distributions_all pd
1103: WHERE pd.po_distribution_id =

Line 1115: per_all_people_f pap

1111: SELECT pap.employee_number
1112: into l_return_val
1113: FROM ap_invoice_distributions_all aid,
1114: po_distributions_all pd,
1115: per_all_people_f pap
1116: WHERE pd.po_distribution_id =aid.po_distribution_id
1117: AND aid.invoice_distribution_id =p_dist_id
1118: AND pd.creation_date >= pap.effective_start_date
1119: AND pd.creation_date <= nvl(pap.effective_end_date,sysdate)