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 1019: select count(*) into l_tx_count from dual

1015: l_return := 'Y';
1016: END ;
1017: -- For checking resource transaction use wip_cost_txn_interface.
1018:
1019: select count(*) into l_tx_count from dual
1020: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1021: WHERE wip_entity_id = p_wip_entity_id
1022: AND operation_seq_num = p_op_seq_num);
1023:

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

1082: **********************************************************************/
1083: function validate_dept_res_instance(p_dept_id number , p_inst_id number, p_res_id Number) return varchar2 is
1084: l_rowcount number := 0;
1085: begin
1086: select count(*) into l_rowcount from dual
1087: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V
1088: where DEPARTMENT_ID=p_dept_id and INSTANCE_ID=p_inst_id and RESOURCE_ID=p_res_id);
1089: if(l_rowcount > 0) then
1090: return 'N';