APPS.PER_ABS_BUS dependencies on PER_BUSINESS_GROUPS

Line 974: per_business_groups pbg

970: cursor c_get_normal_hours (p_assignment_id in number) is
971: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
972: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
973: FROM per_all_assignments_f asg,
974: per_business_groups pbg
975: WHERE asg.assignment_id = p_assignment_id
976: AND asg.business_group_id = pbg.business_group_id
977: AND p_effective_date between asg.effective_start_date
978: and asg.effective_end_date;

Line 1139: per_business_groups pbg

1135: cursor c_get_normal_hours (p_assignment_id in number) is
1136: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
1137: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
1138: FROM per_all_assignments_f asg,
1139: per_business_groups pbg
1140: WHERE asg.assignment_id = p_assignment_id
1141: AND asg.business_group_id = pbg.business_group_id
1142: AND p_effective_date between asg.effective_start_date
1143: and asg.effective_end_date;

Line 2132: from per_business_groups pbg

2128: l_apac_accrual number;
2129:
2130: cursor csr_legislation(p_business_group_id number) is
2131: select pbg.legislation_code
2132: from per_business_groups pbg
2133: where pbg.business_group_id = p_business_group_id;
2134:
2135: -- ********* End Bug 272978 *************
2136:

Line 2374: from per_business_groups pbg

2370: l_apac_accrual number;
2371:
2372: cursor csr_legislation(p_business_group_id number) is
2373: select pbg.legislation_code
2374: from per_business_groups pbg
2375: where pbg.business_group_id = p_business_group_id;
2376:
2377: -- ********* End Bug 272978 *************
2378:

Line 3207: from per_business_groups pbg

3203: -- Declare cursor
3204: --
3205: cursor csr_sec_grp is
3206: select pbg.security_group_id
3207: from per_business_groups pbg
3208: , per_absence_attendances abs
3209: where abs.absence_attendance_id = p_absence_attendance_id
3210: and pbg.business_group_id = abs.business_group_id;
3211: --

Line 3267: from per_business_groups pbg

3263: -- Declare cursor
3264: --
3265: cursor csr_leg_code is
3266: select pbg.legislation_code
3267: from per_business_groups pbg
3268: , per_absence_attendances abs
3269: where abs.absence_attendance_id = p_absence_attendance_id
3270: and pbg.business_group_id = abs.business_group_id;
3271: --