DBA Data[Home] [Help]

APPS.EAM_RES_VALIDATE_PVT dependencies on PO_REQUISITION_HEADERS

Line 961: FROM po_requisition_lines prl, po_requisition_headers prh

957: select count(*)
958: into l_count_req
959: from DUAL
960: WHERE EXISTS (SELECT 1
961: FROM po_requisition_lines prl, po_requisition_headers prh
962: where prl.requisition_header_id = prh.requisition_header_id
963: and prl.wip_entity_id = p_eam_res_rec.wip_entity_id
964: and prl.destination_organization_id = p_eam_res_rec.organization_id
965: and prl.wip_operation_seq_num = p_eam_res_rec.operation_seq_num