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
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,