APPS.EAM_OPERATIONS_JSP dependencies on DUAL

Line 3791: dual

3787: -- check Prior/Next Operation conflict with the modified Start and End Date .
3788: select
3789: count(*) into l_restrict_date_change
3790: from
3791: dual
3792: where
3793: exists
3794: (select '1' from eam_prior_operations_v
3795: where next_operation = p_from_operation

Line 3801: from dual

3797: and wip_entity_id = p_wip_entity_id);
3798:
3799: if(l_restrict_date_change = 0) then
3800: select count(*) into l_restrict_date_change
3801: from dual
3802: where
3803: exists
3804: (select '1' from eam_next_operations_v
3805: where prior_operation = p_from_operation

Line 3837: dual

3833: -- check Prior/Next Operation conflict with the modified Start and End Date .
3834: select
3835: count(*) into l_restrict_date_change
3836: from
3837: dual
3838: where
3839: exists
3840: (select '1' from eam_prior_operations_v
3841: where next_operation = p_to_operation

Line 3847: from dual

3843: and wip_entity_id = p_wip_entity_id);
3844:
3845: if(l_restrict_date_change = 0) then
3846: select count(*) into l_restrict_date_change
3847: from dual
3848: where
3849: exists
3850: (select '1' from eam_next_operations_v
3851: where prior_operation = p_to_operation

Line 3886: from dual

3882: end if;
3883:
3884: -- check for loop in the dependency network
3885: select count(1) into l_loop_available
3886: from dual
3887: where
3888: p_from_operation in (select next_operation
3889: from (select * from wip_operation_networks
3890: where next_operation <> p_to_operation and