APPS.PER_ASG_BUS1 dependencies on PER_BUSINESS_GROUPS_PERF

Line 31: from per_business_groups_perf pbg

27: -- Declare cursor
28: --
29: cursor csr_sec_grp is
30: select pbg.security_group_id, pbg.legislation_code
31: from per_business_groups_perf pbg
32: where pbg.business_group_id = (select distinct asg.business_group_id from
33: per_all_assignments_f asg
34: where asg.assignment_id = p_assignment_id);
35:

Line 3988: from per_business_groups_perf

3984: -- business group.
3985: --
3986: cursor csr_get_bus_legislation_code is
3987: select legislation_code
3988: from per_business_groups_perf
3989: where business_group_id = p_rec.business_group_id;
3990: --
3991: -- Cursor to check if the assignment status type exists in
3992: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.

Line 7129: from per_business_groups_perf pbg

7125: -- -- --Bug fix 3604024. modified cursor to improve performance
7126: --
7127: cursor csr_leg_code is
7128: select pbg.legislation_code
7129: from per_business_groups_perf pbg
7130: where pbg.business_group_id = (select distinct asg.business_group_id from
7131: per_all_assignments_f asg
7132: where asg.assignment_id = p_assignment_id);
7133: