DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on PO_HEADERS

Line 829: po_headers poh

825: SELECT poh.segment1
826: INTO l_po_num
827: FROM ap_invoice_distributions aid,
828: po_distributions pod,
829: po_headers poh
830: WHERE aid.invoice_id = l_invoice_id
831: AND aid.po_distribution_id = pod.po_distribution_id
832: AND pod.po_header_id = poh.po_header_id;
833: ELSE

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