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 4110: from per_business_groups_perf

4106: -- business group.
4107: --
4108: cursor csr_get_bus_legislation_code is
4109: select legislation_code
4110: from per_business_groups_perf
4111: where business_group_id = p_rec.business_group_id;
4112: --
4113: -- Cursor to check if the assignment status type exists in
4114: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.

Line 7315: from per_business_groups_perf pbg

7311: -- -- --Bug fix 3604024. modified cursor to improve performance
7312: --
7313: cursor csr_leg_code is
7314: select pbg.legislation_code
7315: from per_business_groups_perf pbg
7316: where pbg.business_group_id = (select distinct asg.business_group_id from
7317: per_all_assignments_f asg
7318: where asg.assignment_id = p_assignment_id);
7319: