APPS.EAM_WORKORDERS_JSP dependencies on DUAL

Line 280: FROM dual

276: begin
277: begin
278: SELECT '1'
279: INTO network_child_job_var
280: FROM dual
281: WHERE EXISTS (SELECT '1'
282: FROM wip_discrete_jobs
283: WHERE wip_entity_id IN
284: (

Line 313: FROM DUAL

309: WHERE wdj.wip_entity_id=p_wip_entity_id;
310:
311: SELECT '1'
312: INTO dependent_rel
313: FROM DUAL
314: WHERE EXISTS (SELECT ewr.child_object_id
315: FROM EAM_WO_RELATIONSHIPS ewr,WIP_DISCRETE_JOBS wdj
316: WHERE ewr.parent_object_id=p_wip_entity_id AND ewr.parent_relationship_type = 2
317: AND wdj.wip_entity_id=ewr.child_object_id AND (wo_released=1 OR wdj.status_type=3)

Line 2027: from dual;

2023: -- if service request is specified then insert into eam_wo_service_association
2024: if (l_service_request_id is not null) then
2025: select eam_wo_service_association_s.nextval
2026: into l_service_association_id
2027: from dual;
2028:
2029: --Assign only one service request to a work order
2030:
2031: select count(*)

Line 2356: from dual;

2352: -- if service request is specified then insert into eam_wo_service_association
2353: if (l_service_request_id is not null) then
2354: select eam_wo_service_association_s.nextval
2355: into l_service_association_id
2356: from dual;
2357:
2358: insert into eam_wo_service_association
2359: (
2360: wo_service_entity_assoc_id