DBA Data[Home] [Help]

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on DUAL

Line 802: FROM dual

798: -- Replaced the above cursor loop and cursor with the following query.
799: -- for bug #2414513.
800: SELECT '1'
801: INTO child_job_var
802: FROM dual
803: WHERE EXISTS (SELECT '1'
804: FROM wip_discrete_jobs wdj, wip_entities we
805: WHERE wdj.wip_entity_id = we.wip_entity_id
806: AND wdj.parent_wip_entity_id = p_eam_wo_comp_rec.wip_entity_id

Line 875: FROM dual

871: if p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE then
872: begin
873: SELECT '1'
874: INTO network_child_job_var
875: FROM dual
876: WHERE EXISTS ( SELECT '1'
877: FROM wip_discrete_jobs
878: WHERE wip_entity_id IN
879: (

Line 924: FROM dual

920: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
921: begin
922: SELECT '1'
923: INTO sibling_parent_job_var
924: FROM dual
925: WHERE EXISTS (SELECT '1'
926: FROM wip_discrete_jobs
927: WHERE wip_entity_id IN
928: (