APPS.PER_ASG_BUS1 dependencies on PER_BUSINESS_GROUPS

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 3962: l_ast_legislation_code per_business_groups.legislation_code%TYPE;

3958: l_proc varchar2(72) :=
3959: g_package||'chk_assignment_status_type_id';
3960: l_exists varchar2(1);
3961: --
3962: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;

3959: g_package||'chk_assignment_status_type_id';
3960: l_exists varchar2(1);
3961: --
3962: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
3963: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
3964: l_active_flag per_assignment_status_types.active_flag%TYPE;
3965: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
3966: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
3967: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

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: