DBA Data[Home] [Help]

APPS.HR_LOC_ABSENCE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 114: ,per_absence_attendance_types abt

110: ,abs.date_start
111: ,abs.date_end
112: ,abt.absence_category
113: FROM per_absence_attendances abs
114: ,per_absence_attendance_types abt
115: WHERE abs.absence_attendance_id = p_absence_attendance_id
116: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
117: --
118: CURSOR csr_entry_values(p_element_type_id NUMBER, p_iv1_name VARCHAR2, p_iv1_value VARCHAR2, p_effective_date DATE) IS

Line 738: ,per_absence_attendance_types abt

734: ,abs.date_start
735: ,abs.date_end
736: ,abt.absence_category
737: FROM per_absence_attendances abs
738: ,per_absence_attendance_types abt
739: WHERE abs.absence_attendance_id = p_absence_attendance_id
740: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
741:
742: CURSOR csr_legislation_code (p_business_group_id NUMBER) IS

Line 836: ,per_absence_attendance_types abt

832: ,abs.date_start
833: ,abs.date_end
834: ,abt.absence_category
835: FROM per_absence_attendances abs
836: ,per_absence_attendance_types abt
837: WHERE abs.absence_attendance_id = p_absence_attendance_id
838: AND abt.absence_attendance_type_id = abs.absence_attendance_type_id;
839:
840: CURSOR csr_legislation_code (p_business_group_id NUMBER) IS