APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_BUSINESS_GROUPS_PERF

Line 560: from per_business_groups_perf pbg

556: --
557: --
558: cursor csr_get_busgrp_legislation is
559: select pbg.business_group_id, pbg.legislation_code
560: from per_business_groups_perf pbg
561: where pbg.business_group_id = (select distinct asg.business_group_id from
562: per_assignments_f asg
563: where asg.assignment_id = p_assignment_id);
564:

Line 2318: from per_business_groups_perf pbg

2314: --
2315: --
2316: cursor csr_get_busgrp_legislation is
2317: select pbg.business_group_id, pbg.legislation_code
2318: from per_business_groups_perf pbg
2319: where pbg.business_group_id = (select distinct asg.business_group_id from
2320: per_assignments_f asg
2321: where asg.assignment_id = p_assignment_id);
2322: --

Line 4758: , per_business_groups_perf bus

4754: select asg.assignment_type
4755: , asg.business_group_id
4756: , bus.legislation_code
4757: from per_assignments_f asg
4758: , per_business_groups_perf bus
4759: where asg.assignment_id = p_assignment_id
4760: and p_effective_date between asg.effective_start_date
4761: and asg.effective_end_date
4762: and bus.business_group_id+0 = asg.business_group_id;

Line 4923: , per_business_groups_perf bus

4919: select asg.assignment_type
4920: , asg.business_group_id
4921: , bus.legislation_code
4922: from per_assignments_f asg
4923: , per_business_groups_perf bus
4924: where asg.assignment_id = p_assignment_id
4925: and p_effective_date between asg.effective_start_date
4926: and asg.effective_end_date
4927: and bus.business_group_id+0 = asg.business_group_id;

Line 5897: , per_business_groups_perf bus

5893: , asg.person_id
5894: , asg.business_group_id
5895: , bus.legislation_code
5896: from per_assignments_f asg
5897: , per_business_groups_perf bus
5898: where asg.assignment_id = p_assignment_id
5899: and p_effective_date between asg.effective_start_date
5900: and asg.effective_end_date
5901: and bus.business_group_id+0 = asg.business_group_id;