APPS.HR_LEGISLATION_BENEFITS dependencies on PER_COBRA_QFYING_EVENTS_F

Line 68: -- Install procedure to transfer startup delivered per_cobra_qfying_events_f

64:
65: PROCEDURE install_cobra_qfying_events(p_phase IN NUMBER)
66: --------------------------------------------------------
67: IS
68: -- Install procedure to transfer startup delivered per_cobra_qfying_events_f
69: -- into a live account, and remove the then delivered rows from the delivery
70: -- account.
71: -- This procedure is called in two phase. Only in the second phase are
72: -- details transferred into live tables. The parameter p_phase holds

Line 155: from per_cobra_qfying_events_f a

151:
152:
153: select distinct null
154: into l_null_return
155: from per_cobra_qfying_events_f a
156: where exists
157: (select null
158: from hr_s_cobra_qfying_events_f b
159: where a.qualifying_event_id = b.qualifying_event_id

Line 216: hr_legislation.insert_hr_stu_exceptions('per_cobra_qfying_events_f'

212:
213:
214: rollback to new_qualifying_event;
215:
216: hr_legislation.insert_hr_stu_exceptions('per_cobra_qfying_events_f'
217: , r_distinct.c_surrogate_key
218: , exception_type
219: , r_distinct.c_true_key);
220:

Line 254: from per_cobra_qfying_events_f

250:
251: BEGIN
252: select distinct qualifying_event_id
253: into l_new_cqe_id
254: from per_cobra_qfying_events_f
255: where qualifying_event = r_distinct.c_true_key
256: and business_Group_id is null
257: and legislation_code = r_distinct.c_leg_code;
258:

Line 317: from per_cobra_qfying_events_f a

313:
314:
315: select distinct null
316: into l_null_return
317: from per_cobra_qfying_events_f a
318: where a.business_group_id is not null
319: and a.qualifying_event = r_distinct.c_true_key
320: and exists (select null from per_business_groups b
321: where b.business_group_id = a.business_group_id

Line 348: from per_cobra_qfying_events_f

344:
345:
346: select distinct null
347: into l_null_return
348: from per_cobra_qfying_events_f
349: where qualifying_event = r_distinct.c_true_key
350: and legislation_code <> r_distinct.c_leg_code
351: and (legislation_code is null
352: or r_distinct.c_leg_code is null );

Line 507: delete from per_cobra_qfying_events_f

503:
504: -- Phase = 2
505:
506:
507: delete from per_cobra_qfying_events_f
508: where qualifying_event_id = r_distinct.c_surrogate_key;
509:
510: FOR each_row IN c_each_row(r_distinct.c_surrogate_key)
511: LOOP

Line 516: insert into per_cobra_qfying_events_f

512:
513: r_each_row := each_row;
514:
515:
516: insert into per_cobra_qfying_events_f
517: (qualifying_event_id
518: ,effective_start_date
519: ,effective_end_date
520: ,business_group_id