APPS.PER_ABB_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups_perf pbg

25: -- Declare cursor
26: --
27: cursor csr_leg_code is
28: select pbg.legislation_code,abb.business_group_id
29: from per_business_groups_perf pbg
30: , per_absence_attendance_types abb
31: where abb.absence_attendance_type_id = p_absence_attendance_type_id
32: and pbg.business_group_id(+) = abb.business_group_id;
33: --

Line 37: l_business_group_id per_business_groups.business_group_id%type;

33: --
34: -- Declare local variables
35: --
36: l_legislation_code varchar2(150);
37: l_business_group_id per_business_groups.business_group_id%type;
38: l_proc varchar2(72) := g_package||'return_legislation_code';
39: --
40: Begin
41: --

Line 246: from pay_input_values_f piv1, per_business_groups_perf pbg

242: l_input_end date;
243: --
244: cursor csr_valid_input_value_bg is
245: select 1
246: from pay_input_values_f piv1, per_business_groups_perf pbg
247: where piv1.input_value_id = p_input_value_id
248: and pbg.business_group_id = p_business_group_id
249: and nvl(piv1.business_group_id,p_business_group_id) = p_business_group_id
250: and nvl(piv1.legislation_code,pbg.legislation_code) = pbg.legislation_code;

Line 259: from pay_input_values_f piv1, per_business_groups_perf pbg

255: where input_value_id = p_input_value_id;
256: --
257: cursor csr_valid_input_value_dates is
258: select 1
259: from pay_input_values_f piv1, per_business_groups_perf pbg
260: where piv1.input_value_id = p_input_value_id
261: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date
262: and exists (select 1
263: from pay_input_values_f piv2

Line 270: from pay_input_values_f piv1, per_business_groups_perf pbg

266: piv2.effective_start_date and piv2.effective_end_date);
267: --
268: cursor csr_valid_input_value_uom is
269: select 1
270: from pay_input_values_f piv1, per_business_groups_perf pbg
271: where piv1.input_value_id = p_input_value_id
272: and piv1.uom in ('ND','H_HH','H_DECIMAL1','H_DECIMAL2','H_DECIMAL3')
273: and p_date_effective between piv1.effective_start_date and piv1.effective_end_date;
274: --

Line 868: l_leg per_business_groups.legislation_code%TYPE;

864: --
865: l_proc varchar2(72) := g_package || 'chk_information_category';
866: l_api_updating boolean;
867: l_dummy number;
868: l_leg per_business_groups.legislation_code%TYPE;
869: --
870: cursor csr_bg_legislation is
871: select legislation_code
872: from per_business_groups pbg

Line 872: from per_business_groups pbg

868: l_leg per_business_groups.legislation_code%TYPE;
869: --
870: cursor csr_bg_legislation is
871: select legislation_code
872: from per_business_groups pbg
873: where business_group_id = p_business_group_id;
874: --
875: cursor csr_ddf_exist(p_legislation_code varchar2) is
876: select 1