APPS.HR_PUMP_GET dependencies on PER_ABS_ATTENDANCE_TYPES_VL
Line 4834: from per_abs_attendance_types_vl aat
4830: begin
4831: --
4832: select aat.absence_attendance_type_id
4833: into l_absence_attendance_type_id 4834: from per_abs_attendance_types_vl aat 4835: where aat.name = p_aat_user_name
4836: and aat.business_group_id = p_business_group_id
4837: and p_effective_date between
4838: nvl(DATE_EFFECTIVE, START_OF_TIME) AND