APPS.ENG_VALIDATE dependencies on DUAL

Line 1514: FROM SYS.DUAL

1510: , p_operation_seq_num NUMBER
1511: , p_organization_id NUMBER)
1512: IS
1513: SELECT 'Cmp does not exist'
1514: FROM SYS.DUAL
1515: WHERE EXISTS (SELECT NULL
1516: FROM WIP_DISCRETE_JOBS wdj
1517: WHERE (wdj.status_type <> 1
1518: OR

Line 1535: FROM SYS.DUAL

1531: , p_rev_comp_item_id NUMBER
1532: , p_operation_seq_num NUMBER )
1533: IS
1534: SELECT 'Cmp does not exist'
1535: FROM SYS.DUAL
1536: WHERE EXISTS (SELECT NULL
1537: FROM WIP_DISCRETE_JOBS wdj
1538: , WIP_ENTITIES we
1539: , WIP_ENTITIES we1

Line 1561: FROM SYS.DUAL

1557: , p_rev_comp_item_id NUMBER
1558: , p_operation_seq_num NUMBER)
1559: IS
1560: SELECT 'Cmp does not exist'
1561: FROM SYS.DUAL
1562: WHERE EXISTS (SELECT NULL
1563: FROM WIP_DISCRETE_JOBS wdj
1564: WHERE (wdj.status_type <> 1
1565: OR

Line 1774: FROM SYS.DUAL

1770: -- Enhancement for ECO Routing
1771: ******************************************************************/
1772: CURSOR rev_op_seq IS
1773: SELECT 'Rev Op Exist'
1774: FROM SYS.DUAL
1775: WHERE EXISTS ( SELECT NULL
1776: FROM BOM_OPERATION_SEQUENCES
1777: WHERE revised_item_sequence_id =
1778: p_rev_item_unexp_rec.revised_item_sequence_id) ;