6340: 'SUPPLIER_INVOICE_DISTRIBUTION_PO_BUYER_EMP_NUM' THEN
6341:
6342: SELECT employee_number
6343: INTO l_return_val
6344: FROM per_all_people_f pap
6345: WHERE person_id = (SELECT ph.agent_id
6346: FROM ap_invoice_distributions_all aid,
6347: po_distributions_all pd,
6348: po_headers_all ph
6359: 'SUPPLIER_INVOICE_DISTRIBUTION_PO_REQUESTER_EMP_NUM' THEN
6360:
6361: SELECT employee_number
6362: INTO l_return_val
6363: FROM per_all_people_f pap
6364: WHERE person_id = (
6365: SELECT pd.deliver_to_person_id
6366: FROM ap_invoice_distributions_all aid,
6367: po_distributions_all pd