[Home] [Help]
441: into l_null_return
442: from pay_element_classifications a
443: where a.classification_name = stu_rec.c_true_key
444: and a.business_group_id is not null
445: and exists (select null from per_business_groups b
446: where b.business_group_id = a.business_group_id
447: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
448:
449: crt_exc('Row already created in a business group');
1931:
1932:
1933: select distinct null
1934: into l_null_return
1935: from per_business_groups pbg
1936: where pbg.business_group_id = elts.business_group_id
1937: and pbg.legislation_code = r_distinct.legislation_code;
1938:
1939:
3017: into l_null_return
3018: from pay_element_sets a
3019: where a.element_set_name = stu_rec.c_true_key
3020: and a.business_group_id is not null
3021: and exists (select null from per_business_groups b
3022: where b.business_group_id = a.business_group_id
3023: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3024:
3025: crt_exc('Row already created in a business group');
3635: into l_null_return
3636: from pay_user_tables a
3637: where a.user_table_name = stu_rec.c_true_key
3638: and a.business_group_id is not null
3639: and exists (select null from per_business_groups b
3640: where b.business_group_id = a.business_group_id
3641: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3642:
3643: crt_exc('Row already created in a business group');
4278: from pay_user_columns a
4279: where a.user_table_id = stu_rec.user_table_id
4280: and a.user_column_name = stu_rec.c_true_key
4281: and a.business_group_id is not null
4282: and exists (select null from per_business_groups b
4283: where b.business_group_id = a.business_group_id
4284: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
4285:
4286: crt_exc('Row already created in a business group');