DBA Data[Home] [Help]

APPS.EGO_ODI_PUB dependencies on FND_FLEX_VALUE_SETS

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

Line 7204: FROM fnd_flex_value_sets

7200: --Cursor for non versioned VS
7201: CURSOR cur_vs(cp_flex_value_set_id NUMBER)
7202: IS
7203: SELECT Count(flex_value_set_id) vs_count
7204: FROM fnd_flex_value_sets
7205: WHERE flex_value_set_id=cp_flex_value_set_id;
7206:
7207:
7208: CURSOR cur_input_id(cp_session_id NUMBER,