APPS.HR_LEGISLATION_BENEFITS dependencies on PER_BUSINESS_GROUPS

Line 320: and exists (select null from per_business_groups b

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
322: and b.legislation_code = nvl(r_distinct.c_leg_code,b.legislation_code));
323:
324:

Line 863: and exists (select null from per_business_groups b

859: into l_null_return
860: from ben_benefit_classifications a
861: where a.business_group_id is not null
862: and a.benefit_classification_name = stu_rec.c_true_key
863: and exists (select null from per_business_groups b
864: where b.business_group_id = a.business_group_id
865: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
866:
867: crt_exc('Row already created in a business group');

Line 1258: and exists (select null from per_business_groups b

1254: into l_null_return
1255: from ben_valid_dependent_types a
1256: where a.business_group_id is not null
1257: and a.contact_type||a.coverage_type = stu_rec.c_true_key
1258: and exists (select null from per_business_groups b
1259: where b.business_group_id = a.business_group_id
1260: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
1261:
1262: crt_exc('Row already created in a business group');