APPS.HRDYNDBI dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 7166: l_absence_name per_absence_attendance_types.name%type;

7162: (
7163: p_absence_type_id in number
7164: ) is
7165: l_route_name varchar2(50) := 'ABSENCE_SUM_OF_ELEMENT_ENTRY_VALUES';
7166: l_absence_name per_absence_attendance_types.name%type;
7167: l_business_group_id number;
7168: l_created_by number;
7169: l_last_login number;
7170: l_record_inserted boolean;

Line 7186: from per_absence_attendance_types

7182: into l_absence_name,
7183: l_business_group_id,
7184: l_created_by,
7185: l_last_login
7186: from per_absence_attendance_types
7187: where absence_attendance_type_id = p_absence_type_id;
7188: --
7189: -- create the user entity for the route
7190: --

Line 7261: from per_absence_attendance_types;

7257: exist.
7258: */
7259: procedure refresh_absence_types is
7260: cursor c1 is select absence_attendance_type_id type_id
7261: from per_absence_attendance_types;
7262: begin
7263: for c1rec in c1 loop
7264: hrrbdeib_trace_on;
7265: hr_utility.trace ('creating database item absence type id: '||

Line 7288: from per_absence_attendance_types;

7284: exist.
7285: */
7286: procedure delete_absence_types is
7287: cursor c1 is select absence_attendance_type_id type_id
7288: from per_absence_attendance_types;
7289: begin
7290: --
7291: -- delete the absence types
7292: --