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 473: FROM per_business_groups pbg, per_assignments_f paf

469: p_validation_end_date in date) Is
470: --
471: CURSOR c_business_group_legislation IS -- cursor added for 6917434
472: SELECT pbg.legislation_code
473: FROM per_business_groups pbg, per_assignments_f paf
474: WHERE paf.assignment_id = p_assignment_id
475: AND paf.business_group_id = pbg.business_group_id;
476:
477: l_proc varchar2(72) := g_package||'dt_delete_validate';

Line 481: l_legislation_code per_business_groups.legislation_code%type;

477: l_proc varchar2(72) := g_package||'dt_delete_validate';
478: l_rows_exist Exception;
479: l_table_name all_tables.table_name%TYPE;
480:
481: l_legislation_code per_business_groups.legislation_code%type;
482:
483: --
484: Begin
485: if g_debug then

Line 4084: l_ast_legislation_code per_business_groups.legislation_code%TYPE;

4080: l_proc varchar2(72) :=
4081: g_package||'chk_assignment_status_type_id';
4082: l_exists varchar2(1);
4083: --
4084: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;

4081: g_package||'chk_assignment_status_type_id';
4082: l_exists varchar2(1);
4083: --
4084: l_ast_legislation_code per_business_groups.legislation_code%TYPE;
4085: l_bus_legislation_code per_business_groups.legislation_code%TYPE;
4086: l_active_flag per_assignment_status_types.active_flag%TYPE;
4087: l_ast_active_flag per_assignment_status_types.active_flag%TYPE;
4088: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
4089: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

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: