APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on PER_ASSIGNMENTS_F

Line 867: -- Retrieves additional data from per_assignments_f table.

863: p_absence_hours in number,
864: p_date_start in date,
865: p_date_end in date) IS
866: --
867: -- Retrieves additional data from per_assignments_f table.
868: --
869: CURSOR C1 IS
870: SELECT a.business_group_id,
871: a.person_id,

Line 873: FROM per_assignments_f a

869: CURSOR C1 IS
870: SELECT a.business_group_id,
871: a.person_id,
872: a.payroll_id
873: FROM per_assignments_f a
874: WHERE a.assignment_id = p_assignment_id
875: AND p_session_date between a.effective_start_date
876: AND a.effective_end_date;
877: --

Line 1181: -- Retrieves additional data from per_assignments_f table.

1177: l_abs_day_after_warning boolean;
1178: l_dur_overwritten_warning boolean;
1179:
1180: --
1181: -- Retrieves additional data from per_assignments_f table.
1182: --
1183: CURSOR C1 IS
1184: SELECT a.business_group_id,
1185: a.person_id,

Line 1187: FROM per_assignments_f a

1183: CURSOR C1 IS
1184: SELECT a.business_group_id,
1185: a.person_id,
1186: a.payroll_id
1187: FROM per_assignments_f a
1188: WHERE a.assignment_id = p_assignment_id
1189: AND p_session_date between a.effective_start_date
1190: AND a.effective_end_date;
1191:

Line 1198: FROM per_assignments_f asg,

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