51: l_ref_code VARCHAR2(30);
52:
53: CURSOR c_id IS
54: SELECT AMS_IBA_PS_CNDCLSES_B_s.NEXTVAL
55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM AMS_IBA_PS_CNDCLSES_B
514: 'CV3', 'use_clause8',
515: 'CV4', 'use_clause9',
516: 'CV5', 'use_clause10')
517: into l_wclause
518: from dual;
519:
520: l_query := 'select count(*) from ams_iba_ps_rules where ';
521: execute immediate l_query || l_wclause || ' = ''Y''' into l_count;
522: