APPS.EGO_PUB_WS_AG dependencies on DUAL

Line 480: FROM dual;

476:
477: -- get next value for the sequence_id
478: SELECT EGO_PUB_WS_ENTITIES_S.nextval
479: INTO l_seq_id
480: FROM dual;
481:
482: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
483: ODI_SESSION_ID,
484: SEQUENCE_ID,

Line 623: FROM dual;

619:
620: -- get next value for the sequence_id
621: SELECT EGO_PUB_WS_ENTITIES_S.nextval
622: INTO l_seq_id
623: FROM dual;
624:
625: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
626: ODI_SESSION_ID,
627: SEQUENCE_ID,

Line 684: FROM DUAL WHERE EXISTS (

680:
681: CURSOR CUR_CHILD_VS ( p_valueset_id NUMBER)
682: IS
683: SELECT 1
684: FROM DUAL WHERE EXISTS (
685: SELECT NULL
686: FROM ego_value_set_ext evse
687: WHERE evse.value_set_id = p_valueset_id
688: );

Line 859: FROM dual;

855:
856: -- get next value for the sequence_id
857: SELECT EGO_PUB_WS_ENTITIES_S.nextval
858: INTO l_seq_id
859: FROM dual;
860:
861: -- as value set does not exist in input table, insert value set record and
862: -- insert its association to attribute group
863: