DBA Data[Home] [Help]

APPS.HR_LEGISLATION_BENEFITS dependencies on PER_COBRA_QFYING_EVENTS_S

Line 184: select per_cobra_qfying_events_s.nextval

180: into v_min_delivered
181: , v_max_delivered
182: from hr_s_cobra_qfying_events_f;
183:
184: select per_cobra_qfying_events_s.nextval
185: into v_sequence_number
186: from dual;
187:
188: WHILE v_sequence_number BETWEEN v_min_delivered AND v_max_delivered LOOP

Line 191: select per_cobra_qfying_events_s.nextval

187:
188: WHILE v_sequence_number BETWEEN v_min_delivered AND v_max_delivered LOOP
189:
190:
191: select per_cobra_qfying_events_s.nextval
192: into v_sequence_number
193: from dual;
194:
195: END LOOP;

Line 262: select per_cobra_qfying_events_s.nextval

258:
259: EXCEPTION WHEN NO_DATA_FOUND THEN
260:
261:
262: select per_cobra_qfying_events_s.nextval
263: into l_new_cqe_id
264: from dual;
265:
266: WHEN TOO_MANY_ROWS THEN