APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 2385: from per_absence_attendance_types abt

2381: and nvl(hl.end_date_active, p_date);
2382: --
2383: cursor c_get_mapping_name5(p_id in number,p_date in date) is
2384: select abt.name
2385: from per_absence_attendance_types abt
2386: where abt.business_group_id = p_business_group_id
2387: and abt.absence_attendance_type_id = p_id
2388: and p_date between abt.date_effective
2389: and nvl(abt.date_end, p_date);

Line 2394: from per_absence_attendance_types

2390: --
2391:
2392: cursor c_absence_type_start_date(c_absence_attendance_type_id number) is
2393: select date_effective
2394: from per_absence_attendance_types
2395: where absence_attendance_type_id = c_absence_attendance_type_id;
2396:
2397: l_absence_type_start_date per_absence_attendance_types.date_effective%type;
2398: l_mapping_id1 number;

Line 2397: l_absence_type_start_date per_absence_attendance_types.date_effective%type;

2393: select date_effective
2394: from per_absence_attendance_types
2395: where absence_attendance_type_id = c_absence_attendance_type_id;
2396:
2397: l_absence_type_start_date per_absence_attendance_types.date_effective%type;
2398: l_mapping_id1 number;
2399: l_mapping_name1 varchar2(600);
2400: --l_mapping_column_name1 pqh_attributes.attribute_name%type;
2401: --l_mapping_column_name2 pqh_attributes.attribute_name%type;