APPS.PO_VENDORMERGE_GRP dependencies on PO_REQUISITION_HEADERS_ALL

Line 390: FROM Po_Requisition_Headers_All prha

386: from po_vendor_sites pvs2
387: where vendor_site_id =
388: p_dup_vendor_site_id)
389: AND NOT EXISTS (SELECT 'CLM Document'
390: FROM Po_Requisition_Headers_All prha
391: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
392: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
393:
394:

Line 403: FROM Po_Requisition_Headers_All prha

399: prl.last_updated_by = l_last_updated_by
400: WHERE prl.vendor_id = p_dup_vendor_id
401: AND prl.vendor_site_id = p_dup_vendor_site_id
402: AND NOT EXISTS (SELECT 'CLM Document'
403: FROM Po_Requisition_Headers_All prha
404: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
405: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
406:
407:

Line 420: FROM Po_Requisition_Headers_All prha

416: from po_vendors
417: where vendor_id = p_dup_vendor_id
418: and nvl(end_date_active, sysdate+1) <= sysdate)
419: AND NOT EXISTS (SELECT 'Exclude CLM Document'
420: FROM Po_Requisition_Headers_All prha
421: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
422: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
423:
424: IF (PO_LOG.d_stmt) THEN