DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on HZ_PARTIES

Line 649: hz_parties HP ,

645:
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'