APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_BUSINESS_GROUPS_PERF

Line 525: from per_business_groups_perf pbg

521: --
522: --
523: cursor csr_get_busgrp_legislation is
524: select pbg.business_group_id, pbg.legislation_code
525: from per_business_groups_perf pbg
526: where pbg.business_group_id = (select distinct asg.business_group_id from
527: per_assignments_f asg
528: where asg.assignment_id = p_assignment_id);
529:

Line 2216: from per_business_groups_perf pbg

2212: --
2213: --
2214: cursor csr_get_busgrp_legislation is
2215: select pbg.business_group_id, pbg.legislation_code
2216: from per_business_groups_perf pbg
2217: where pbg.business_group_id = (select distinct asg.business_group_id from
2218: per_assignments_f asg
2219: where asg.assignment_id = p_assignment_id);
2220: --

Line 4625: , per_business_groups_perf bus

4621: select asg.assignment_type
4622: , asg.business_group_id
4623: , bus.legislation_code
4624: from per_assignments_f asg
4625: , per_business_groups_perf bus
4626: where asg.assignment_id = p_assignment_id
4627: and p_effective_date between asg.effective_start_date
4628: and asg.effective_end_date
4629: and bus.business_group_id+0 = asg.business_group_id;

Line 4790: , per_business_groups_perf bus

4786: select asg.assignment_type
4787: , asg.business_group_id
4788: , bus.legislation_code
4789: from per_assignments_f asg
4790: , per_business_groups_perf bus
4791: where asg.assignment_id = p_assignment_id
4792: and p_effective_date between asg.effective_start_date
4793: and asg.effective_end_date
4794: and bus.business_group_id+0 = asg.business_group_id;

Line 5762: , per_business_groups_perf bus

5758: , asg.person_id
5759: , asg.business_group_id
5760: , bus.legislation_code
5761: from per_assignments_f asg
5762: , per_business_groups_perf bus
5763: where asg.assignment_id = p_assignment_id
5764: and p_effective_date between asg.effective_start_date
5765: and asg.effective_end_date
5766: and bus.business_group_id+0 = asg.business_group_id;