APPS.HR_LEGISLATION dependencies on PER_BUSINESS_GROUPS

Line 1157: , per_business_groups b

1153: where exists (
1154:
1155: select null
1156: from per_assignment_status_types a
1157: , per_business_groups b
1158: where a.default_flag = 'Y'
1159: and a.per_system_status = stu_rec.per_system_status
1160: and ( (a.business_group_id is not null
1161: and b.business_group_id = a.business_group_id

Line 1485: and exists (select null from per_business_groups b

1481: into l_null_return
1482: from pay_balance_categories_f a
1483: where a.category_name = r_distinct.c_true_key
1484: and a.business_group_id is not null
1485: and exists (select null from per_business_groups b
1486: where b.business_group_id = a.business_group_id
1487: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
1488:
1489: crt_exc('Row already created in a business group');

Line 2245: from per_business_groups pbg

2241: BEGIN
2242:
2243: select distinct null
2244: into l_null_return
2245: from per_business_groups pbg
2246: where pbg.business_group_id = bals.business_group_id
2247: and pbg.legislation_code = stu_rec.c_leg_code;
2248:
2249: crt_exc('Row already created in a business group');

Line 3182: and exists (select null from per_business_groups b

3178: select distinct null
3179: from pay_balance_dimensions a
3180: where a.dimension_name = stu_rec.c_true_key
3181: and a.business_group_id is not null
3182: and exists (select null from per_business_groups b
3183: where b.business_group_id = a.business_group_id
3184: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3185:
3186: cursor c_get_baldim_null is

Line 4967: and exists (select null from per_business_groups b

4963: and a.row_low_range_or_name = r_distinct.c_true_key
4964: and nvl(row_high_range, 'NULL') =
4965: nvl(r_distinct.row_high_range, 'NULL')
4966: and a.business_group_id is not null
4967: and exists (select null from per_business_groups b
4968: where b.business_group_id = a.business_group_id
4969: and b.legislation_code = nvl(r_distinct.legislation_code,b.legislation_code));
4970:
4971: crt_exc('Row already created in a business group');

Line 5652: and exists (select null from per_business_groups b

5648: from pay_monetary_units a
5649: where a.monetary_unit_name = stu_rec.c_true_key
5650: and a.currency_code = stu_rec.currency_code
5651: and a.business_group_id is not null
5652: and exists (select null from per_business_groups b
5653: where b.business_group_id = a.business_group_id
5654: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
5655:
5656: crt_exc('Row already created in a business group');