APPS.HR_LEGISLATION_BENEFITS dependencies on DUAL

Line 186: from dual;

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
189:
190:

Line 193: from dual;

189:
190:
191: select per_cobra_qfying_events_s.nextval
192: into v_sequence_number
193: from dual;
194:
195: END LOOP;
196:
197: END check_next_sequence;

Line 264: from dual;

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
267: hr_legislation.hrrunprc_trace_on;
268: hr_utility.trace('qualifying_event_id TMR: ' || r_distinct.c_true_key);

Line 391: from dual

387:
388: if (r_distinct.c_leg_sgrp is null) then
389: select null --if exception raised then this row is not needed
390: into l_null_return
391: from dual
392: where exists
393: (select null
394: from hr_s_application_ownerships a
395: , fnd_product_installations b

Line 407: from dual

403: (b.status in ('I', 'S') and c.application_short_name = 'PQP')));
404: else
405: select null --if exception raised then this row is not needed
406: into l_null_return
407: from dual
408: where exists
409: (select null
410: from hr_s_application_ownerships a
411: , fnd_product_installations b

Line 672: from dual;

668: from hr_s_benefit_classifications;
669:
670: select ben_benefit_classifications_s.nextval
671: into v_sequence_number
672: from dual;
673:
674: WHILE
675: v_sequence_number BETWEEN v_min_delivered AND v_max_delivered
676: LOOP

Line 681: from dual;

677:
678:
679: select ben_benefit_classifications_s.nextval
680: into v_sequence_number
681: from dual;
682:
683: END LOOP;
684:
685: END check_next_sequence;

Line 734: from dual;

730:
731:
732: select ben_benefit_classifications_s.nextval
733: into l_new_surrogate_key
734: from dual;
735:
736: END;
737:
738: -- Update all child entities

Line 810: from dual

806: -- If exception raised below then this row is not needed
807:
808: select null
809: into l_null_return
810: from dual
811: where exists
812: (select null
813: from hr_s_application_ownerships a
814: , fnd_product_installations b

Line 1138: from dual;

1134:
1135:
1136: select ben_valid_dependent_types_s.nextval
1137: into l_new_surrogate_key
1138: from dual;
1139:
1140: END;
1141:
1142: --update all child entities

Line 1205: from dual

1201:
1202:
1203: select null --if exception raised then this row is not needed
1204: into l_null_return
1205: from dual
1206: where exists
1207: (select null
1208: from hr_s_application_ownerships a
1209: , fnd_product_installations b