APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on PER_BUSINESS_GROUPS

Line 185: from per_business_groups

181: and piv.effective_end_date;
182:
183: cursor c2 is
184: select legislation_code
185: from per_business_groups
186: where business_group_id = p_business_group_id;
187:
188:
189: begin

Line 1199: per_business_groups pbg

1195: CURSOR C2 IS
1196: SELECT nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
1197: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
1198: FROM per_assignments_f asg,
1199: per_business_groups pbg
1200: WHERE asg.assignment_id = p_assignment_id
1201: AND asg.business_group_id = pbg.business_group_id
1202: AND p_session_date between asg.effective_start_date
1203: and asg.effective_end_date;

Line 1216: per_business_groups_perf pbg

1212: --
1213: cursor C3 IS
1214: SELECT null
1215: FROM per_absence_attendance_types paat,
1216: per_business_groups_perf pbg
1217: WHERE pbg.business_group_id = l_business_group_id
1218: AND pbg.legislation_code = 'GB'
1219: AND paat.absence_attendance_type_id = p_absence_att_type_id
1220: AND paat.absence_category='S';