DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on PO_HEADERS_ALL

Line 1070: po_headers_all ph

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
1071: WHERE pd.po_distribution_id =
1072: aid.po_distribution_id
1073: AND pd.po_header_id = ph.po_header_id
1074: AND aid.invoice_distribution_id =

Line 1084: PO_HEADERS_ALL PH,

1080: SELECT Pap.EMPLOYEE_NUMBER
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