APPS.EAM_OP_VALIDATE_PVT dependencies on DUAL

Line 168: from dual

164:
165: --check if any stocked/non-stocked inventory items exist for this op
166: select count(*)
167: into l_inv_count
168: from dual
169: where exists (select 1
170: from wip_requirement_operations wro
171: where wro.wip_entity_id = p_wip_entity_id
172: and wro.organization_id = p_organization_id

Line 189: from dual

185:
186: --check if any resources exist for this op
187: select count(*)
188: into l_res_count
189: from dual
190: where exists (select 1
191: from wip_operation_resources
192: where wip_entity_id = p_wip_entity_id
193: and organization_id = p_organization_id

Line 203: from DUAL

199:
200: --check if any pending requisitions exist for this op
201: /* select count(*)
202: into l_po_count
203: from DUAL
204: WHERE EXISTS (SELECT 1
205: FROM po_requisitions_interface
206: where wip_entity_id = p_wip_entity_id
207: and destination_organization_id = p_organization_id

Line 218: from DUAL

214:
215: --check if any requisitions exist for this op
216: select count(*)
217: into l_req_count
218: from DUAL
219: WHERE EXISTS (SELECT 1
220: FROM po_requisition_lines prl, po_requisition_headers prh
221: where prl.requisition_header_id = prh.requisition_header_id
222: and prl.wip_entity_id = p_wip_entity_id

Line 242: from DUAL

238:
239: --check if any purchase orders exist for this op
240: select count(*)
241: into l_dist_count
242: from DUAL
243: WHERE EXISTS (SELECT 1
244: FROM po_distributions pds,po_line_locations poll
245: where pds.line_location_id = poll.line_location_id
246: and pds.wip_entity_id = p_wip_entity_id

Line 1066: select count(*) into l_tx_count from dual

1062: l_return := 'Y';
1063: END ;
1064: -- For checking resource transaction use wip_cost_txn_interface.
1065:
1066: select count(*) into l_tx_count from dual
1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1068: WHERE wip_entity_id = p_wip_entity_id
1069: AND operation_seq_num = p_op_seq_num);
1070:

Line 1137: select count(*) into l_rowcount from dual

1133: **********************************************************************/
1134: function validate_dept_res_instance(p_dept_id number , p_inst_id number, p_res_id Number) return varchar2 is
1135: l_rowcount number := 0;
1136: begin
1137: select count(*) into l_rowcount from dual
1138: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V
1139: where DEPARTMENT_ID=p_dept_id and INSTANCE_ID=p_inst_id and RESOURCE_ID=p_res_id);
1140: if(l_rowcount > 0) then
1141: return 'N';