APPS.EGO_ODI_PUB dependencies on EGO_FLEX_VALUESET_VERSION_B

Line 6593: FROM EGO_FLEX_VALUESET_VERSION_B

6589: CONNECT BY PRIOR value_set_id = parent_value_set_id
6590: )
6591: UNION ALL
6592: /*( SELECT flex_value_set_id value_set_id ,version_seq_id
6593: FROM EGO_FLEX_VALUESET_VERSION_B
6594: WHERE flex_value_set_id= cp_value_set_id
6595: AND cp_version_seq_id IS NOT NULL
6596: AND NVL(end_active_date, sysdate) >= SYSDATE
6597: AND start_active_date <= SYSDATE

Line 6668: FROM EGO_FLEX_VALUESET_VERSION_B

6664: and store in version array table*/
6665: IF l_dup_vs_ver_tab(i)=-1 THEN
6666: BEGIN
6667: SELECT version_seq_id INTO l_dup_vs_ver_tab(i)
6668: FROM EGO_FLEX_VALUESET_VERSION_B
6669: WHERE NVL(end_active_date, sysdate) >= SYSDATE
6670: AND start_active_date <= SYSDATE
6671: AND FLEX_VALUE_SET_ID = l_dup_vs_id_tab(i)
6672: AND version_seq_id > 0;

Line 6777: FROM EGO_FLEX_VALUESET_VERSION_B

6773: and store in version array table*/
6774: IF l_dup_vs_ver_tab(i)=-1 THEN
6775: BEGIN
6776: SELECT version_seq_id INTO l_dup_vs_ver_tab(i)
6777: FROM EGO_FLEX_VALUESET_VERSION_B
6778: WHERE NVL(end_active_date, sysdate) >= SYSDATE
6779: AND start_active_date <= SYSDATE
6780: AND FLEX_VALUE_SET_ID = l_dup_vs_id_tab(i)
6781: AND version_seq_id > 0;

Line 7192: FROM fnd_flex_value_sets base ,EGO_FLEX_VALUESET_VERSION_B vers

7188: CURSOR cur_ver_vs( cp_flex_value_set_id NUMBER,
7189: cp_version_seq_id NUMBER)
7190: IS
7191: SELECT Count(base.flex_value_set_id) ver_vs_count
7192: FROM fnd_flex_value_sets base ,EGO_FLEX_VALUESET_VERSION_B vers
7193: WHERE base.flex_value_set_id= vers.flex_value_set_id
7194: AND base.flex_value_set_id=cp_flex_value_set_id
7195: AND vers.version_seq_id =Nvl(cp_version_seq_id,vers.version_seq_id)
7196: AND vers.version_seq_id >0; --Yjain