APPS.PER_ABS_BUS dependencies on PER_BUSINESS_GROUPS

Line 970: per_business_groups pbg

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

Line 2020: from per_business_groups pbg

2016: l_apac_accrual number;
2017:
2018: cursor csr_legislation(p_business_group_id number) is
2019: select pbg.legislation_code
2020: from per_business_groups pbg
2021: where pbg.business_group_id = p_business_group_id;
2022:
2023: -- ********* End Bug 272978 *************
2024:

Line 2775: from per_business_groups pbg

2771: -- Declare cursor
2772: --
2773: cursor csr_sec_grp is
2774: select pbg.security_group_id
2775: from per_business_groups pbg
2776: , per_absence_attendances abs
2777: where abs.absence_attendance_id = p_absence_attendance_id
2778: and pbg.business_group_id = abs.business_group_id;
2779: --

Line 2835: from per_business_groups pbg

2831: -- Declare cursor
2832: --
2833: cursor csr_leg_code is
2834: select pbg.legislation_code
2835: from per_business_groups pbg
2836: , per_absence_attendances abs
2837: where abs.absence_attendance_id = p_absence_attendance_id
2838: and pbg.business_group_id = abs.business_group_id;
2839: --