APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 6409: from per_absence_attendance_types abt

6405: -- pabodla : mapping data
6406: --
6407: cursor c_get_mapping_name7(p_id in number,p_date in date) is
6408: select abt.name
6409: from per_absence_attendance_types abt
6410: where abt.business_group_id = p_business_group_id
6411: and abt.absence_attendance_type_id = p_id
6412: and p_date between abt.date_effective
6413: and nvl(abt.date_end, p_date);

Line 6433: from per_absence_attendance_types

6429: --
6430:
6431: cursor c_absence_type_start_date(c_absence_attendance_type_id number) is
6432: select date_effective
6433: from per_absence_attendance_types
6434: where absence_attendance_type_id = c_absence_attendance_type_id;
6435:
6436: l_absence_type_start_date per_absence_attendance_types.date_effective%type;
6437: ---------------------------------------------------------------

Line 6436: l_absence_type_start_date per_absence_attendance_types.date_effective%type;

6432: select date_effective
6433: from per_absence_attendance_types
6434: where absence_attendance_type_id = c_absence_attendance_type_id;
6435:
6436: l_absence_type_start_date per_absence_attendance_types.date_effective%type;
6437: ---------------------------------------------------------------
6438: -- END OF BEN_LOA_RSN_RT_F ----------------------
6439: ---------------------------------------------------------------
6440: ---------------------------------------------------------------