APPS.BOM_OP_SEQ_UTIL dependencies on DUAL

Line 482: FROM DUAL

478: , p_alternate_rtg_code VARCHAR2
479: )
480: IS
481: SELECT 'Routing Exists'
482: FROM DUAL
483: WHERE NOT EXISTS ( SELECT routing_sequence_id
484: FROM bom_operational_routings
485: WHERE assembly_item_id = p_revised_item_id
486: AND organization_id = p_organization_id

Line 504: FROM DUAL ;

500: -- Get Routing_Sequence_id
501: CURSOR l_get_rtg_seq_csr
502: IS
503: SELECT bom_operational_routings_s.NEXTVAL routing_sequence_id
504: FROM DUAL ;
505:
506: BEGIN
507: --
508: -- Initialize Common Record and Status