DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1316: from per_absence_attendance_types abt

1312: cursor c_AttendenceTypeNameLovVO(p_source_name1 varchar2,
1313: cv_effective_date date) is
1314: select abt.name Name,
1315: abt.absence_attendance_type_id id
1316: from per_absence_attendance_types abt
1317: where trunc(cv_effective_date)
1318: between Date_Effective and nvl(Date_end, trunc(cv_effective_date))
1319: and business_group_id = p_target_business_group_id
1320: and abt.name = p_source_name1;