APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 818: RETURN per_absence_attendance_types.NAME%TYPE

814: -- ----------------------------------------------------------------------------
815: -- |----------------------< get_abs_type_name >-----------------------------|
816: -- ----------------------------------------------------------------------------
817: FUNCTION get_abs_type_name(p_absence_type_id IN NUMBER)
818: RETURN per_absence_attendance_types.NAME%TYPE
819: IS
820: --
821: CURSOR csr_get_abs_type_name
822: IS

Line 824: FROM per_absence_attendance_types

820: --
821: CURSOR csr_get_abs_type_name
822: IS
823: SELECT NAME
824: FROM per_absence_attendance_types
825: WHERE absence_attendance_type_id = p_absence_type_id;
826:
827: l_proc_name VARCHAR2(80) := g_proc_name || 'get_abs_type_name';
828: l_proc_step PLS_INTEGER;

Line 829: l_abs_type_name per_absence_attendance_types.NAME%TYPE;

825: WHERE absence_attendance_type_id = p_absence_type_id;
826:
827: l_proc_name VARCHAR2(80) := g_proc_name || 'get_abs_type_name';
828: l_proc_step PLS_INTEGER;
829: l_abs_type_name per_absence_attendance_types.NAME%TYPE;
830: --
831: BEGIN
832: --
833: IF g_debug

Line 1006: l_abs_type_name per_absence_attendance_types.NAME%TYPE;

1002: l_new_joiner VARCHAR2(10);
1003: l_ret_break VARCHAR2(10);
1004: l_meaning hr_lookups.meaning%TYPE;
1005: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1006: l_abs_type_name per_absence_attendance_types.NAME%TYPE;
1007: l_asg_status per_assignment_status_types.user_status%TYPE;
1008: l_miss_events VARCHAR2(32000);
1009: --
1010: BEGIN