[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');
1910:
1911:
1912: select distinct null
1913: into l_null_return
1914: from per_business_groups pbg
1915: where pbg.business_group_id = elts.business_group_id
1916: and pbg.legislation_code = r_distinct.legislation_code;
1917:
1918:
2985: into l_null_return
2986: from pay_element_sets a
2987: where a.element_set_name = stu_rec.c_true_key
2988: and a.business_group_id is not null
2989: and exists (select null from per_business_groups b
2990: where b.business_group_id = a.business_group_id
2991: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
2992:
2993: crt_exc('Row already created in a business group');
3603: into l_null_return
3604: from pay_user_tables a
3605: where a.user_table_name = stu_rec.c_true_key
3606: and a.business_group_id is not null
3607: and exists (select null from per_business_groups b
3608: where b.business_group_id = a.business_group_id
3609: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3610:
3611: crt_exc('Row already created in a business group');
4246: from pay_user_columns a
4247: where a.user_table_id = stu_rec.user_table_id
4248: and a.user_column_name = stu_rec.c_true_key
4249: and a.business_group_id is not null
4250: and exists (select null from per_business_groups b
4251: where b.business_group_id = a.business_group_id
4252: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
4253:
4254: crt_exc('Row already created in a business group');