APPS.EAM_RES_VALIDATE_PVT dependencies on DUAL

Line 828: from DUAL

824: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
825:
826: select count(*)
827: into l_count_wt
828: from DUAL
829: WHERE EXISTS (SELECT 1
830: FROM wip_transactions
831: where wip_entity_id = p_eam_res_rec.wip_entity_id
832: and organization_id = p_eam_res_rec.organization_id

Line 843: from DUAL

839: end if;
840:
841: select count(*)
842: into l_count_wcti
843: from DUAL
844: WHERE EXISTS (SELECT 1
845: FROM wip_cost_txn_interface
846: where wip_entity_id = p_eam_res_rec.wip_entity_id
847: and organization_id = p_eam_res_rec.organization_id

Line 943: from DUAL

939: if (p_eam_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
940:
941: select count(*)
942: into l_count_po
943: from DUAL
944: WHERE EXISTS (SELECT 1
945: FROM po_requisitions_interface_all
946: where wip_entity_id = p_eam_res_rec.wip_entity_id
947: and destination_organization_id = p_eam_res_rec.organization_id

Line 959: from DUAL

955:
956:
957: select count(*)
958: into l_count_req
959: from DUAL
960: WHERE EXISTS (SELECT 1
961: FROM po_requisition_lines_all prl, po_requisition_headers_all prh
962: where prl.requisition_header_id = prh.requisition_header_id
963: and prl.wip_entity_id = p_eam_res_rec.wip_entity_id

Line 984: from DUAL

980:
981:
982: select count(*)
983: into l_count_dist
984: from DUAL
985: WHERE EXISTS (SELECT 1
986: FROM po_distributions_all pds,po_line_locations_all poll
987: where pds.line_location_id = poll.line_location_id
988: and pds.wip_entity_id = p_eam_res_rec.wip_entity_id