APPS.EGO_ODI_PUB dependencies on DUAL

Line 5280: FROM DUAL;

5276: WHERE session_id = cp_session_id AND NVL (parent_sequence_id, -1) = -1)
5277: CONNECT BY PRIOR sequence_id = parent_sequence_id AND session_id = cp_session_id
5278: UNION ALL
5279: SELECT -99999, NULL, 'ITEM',1
5280: FROM DUAL;
5281:
5282: --YJAIN
5283: /*Cursor to get top level entity value and sequence*/
5284: CURSOR c_ws_entity_val (cp_session_id NUMBER,cp_sequence_id NUMBER,cp_parent_sequence_id NUMBER)

Line 6138: SELECT cp_icc_id ITEM_CATALOG_GROUP_ID,cp_icc_ver VERSION_SEQ_ID,1 lev FROM dual

6134: 3. current date for publishing ICC's effective in present.*/
6135:
6136: CURSOR cur_icc_ver(cp_icc_id IN NUMBER, cp_icc_ver IN NUMBER,cp_publish_parent IN VARCHAR2, cp_publish_child IN VARCHAR2)
6137: IS
6138: SELECT cp_icc_id ITEM_CATALOG_GROUP_ID,cp_icc_ver VERSION_SEQ_ID,1 lev FROM dual
6139: UNION
6140: SELECT ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID,lev FROM
6141: ( SELECT iccb.ITEM_CATALOG_GROUP_ID,VERSION_SEQ_ID ,lev
6142: FROM EGO_MTL_CATALOG_GRP_VERS_B iccb,

Line 6601: FROM dual

6597: AND start_active_date <= SYSDATE
6598: AND version_seq_id>0
6599: ) */
6600: (SELECT cp_value_set_id AS value_set_id, cp_version_seq_id AS version_seq_id
6601: FROM dual
6602: WHERE cp_version_seq_id IS NOT NULL
6603: )
6604: );
6605:

Line 7558: FROM dual

7554: l_icc_ta_metadata_tbl(i).checkeligibility AS CheckEligibility,
7555: l_is_inherited AS INHERITED,
7556: l_is_modified AS MODIFIED ).getclobval(),
7557: SYSDATE
7558: FROM dual
7559: );
7560:
7561: END LOOP;
7562: END LOOP;