DBA Data[Home] [Help]

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