APPS.HR_LEGISLATION dependencies on PER_BUSINESS_GROUPS

Line 952: , per_business_groups b

948: where exists (
949:
950: select null
951: from per_assignment_status_types a
952: , per_business_groups b
953: where a.default_flag = 'Y'
954: and a.per_system_status = stu_rec.per_system_status
955: and ( (a.business_group_id is not null
956: and b.business_group_id = a.business_group_id

Line 1280: and exists (select null from per_business_groups b

1276: into l_null_return
1277: from pay_balance_categories_f a
1278: where a.category_name = r_distinct.c_true_key
1279: and a.business_group_id is not null
1280: and exists (select null from per_business_groups b
1281: where b.business_group_id = a.business_group_id
1282: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
1283:
1284: crt_exc('Row already created in a business group');

Line 2028: from per_business_groups pbg

2024: BEGIN
2025:
2026: select distinct null
2027: into l_null_return
2028: from per_business_groups pbg
2029: where pbg.business_group_id = bals.business_group_id
2030: and pbg.legislation_code = stu_rec.c_leg_code;
2031:
2032: crt_exc('Row already created in a business group');

Line 2936: and exists (select null from per_business_groups b

2932: select distinct null
2933: from pay_balance_dimensions a
2934: where a.dimension_name = stu_rec.c_true_key
2935: and a.business_group_id is not null
2936: and exists (select null from per_business_groups b
2937: where b.business_group_id = a.business_group_id
2938: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
2939:
2940: cursor c_get_baldim_null is

Line 4717: and exists (select null from per_business_groups b

4713: and a.row_low_range_or_name = r_distinct.c_true_key
4714: and nvl(row_high_range, 'NULL') =
4715: nvl(r_distinct.row_high_range, 'NULL')
4716: and a.business_group_id is not null
4717: and exists (select null from per_business_groups b
4718: where b.business_group_id = a.business_group_id
4719: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
4720:
4721: crt_exc('Row already created in a business group');

Line 5402: and exists (select null from per_business_groups b

5398: from pay_monetary_units a
5399: where a.monetary_unit_name = stu_rec.c_true_key
5400: and a.currency_code = stu_rec.currency_code
5401: and a.business_group_id is not null
5402: and exists (select null from per_business_groups b
5403: where b.business_group_id = a.business_group_id
5404: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
5405:
5406: crt_exc('Row already created in a business group');