DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ABS_ATTENDANCE_TYPES_VL

Line 4861: from per_abs_attendance_types_vl aat

4857: begin
4858: --
4859: select aat.absence_attendance_type_id
4860: into l_absence_attendance_type_id
4861: from per_abs_attendance_types_vl aat
4862: where aat.name = p_aat_user_name
4863: and aat.business_group_id = p_business_group_id
4864: and p_effective_date between
4865: nvl(DATE_EFFECTIVE, START_OF_TIME) AND