APPS.PER_ABB_BUS dependencies on PER_BUSINESS_GROUPS_PERF

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 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: --