DBA Data[Home] [Help]

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 1065: FROM per_all_people_f pap

1061: 'SUPPLIER_INVOICE_DISTRIBUTION_PO_BUYER_EMP_NUM' THEN
1062:
1063: SELECT employee_number
1064: INTO l_return_val
1065: FROM per_all_people_f pap
1066: WHERE person_id = (SELECT ph.agent_id
1067: FROM ap_invoice_distributions_all aid,
1068: po_distributions_all pd,
1069: po_headers_all ph

Line 1083: FROM per_all_people_f pap

1079: 'SUPPLIER_INVOICE_DISTRIBUTION_PO_REQUESTER_EMP_NUM' THEN
1080:
1081: SELECT employee_number
1082: INTO l_return_val
1083: FROM per_all_people_f pap
1084: WHERE person_id = (SELECT pd.deliver_to_person_id
1085: FROM ap_invoice_distributions_all aid,
1086: po_distributions_all pd
1087: WHERE pd.po_distribution_id =