DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 650: HR_ALL_ORGANIZATION_UNITS org ,

646: CURSOR c_pending_deliverables(p_po_header_id IN NUMBER) IS
647: SELECT DISTINCT OD.business_document_number, OD.creation_date -- Added for the bug 13617899
648: FROM OKC_DELIVERABLES OD ,
649: hz_parties HP ,
650: HR_ALL_ORGANIZATION_UNITS org ,
651: okc_resp_parties_tl resp_party_tl
652: WHERE OD.BUSINESS_DOCUMENT_ID = p_po_header_id
653: AND OD.BUSINESS_DOCUMENT_TYPE = 'PO_STANDARD'
654: AND OD.external_party_contact_id = HP.party_id (+)