APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 2899: -- DK Resolve from Table PER_ABSENCE_ATTENDANCE_TYPES

2895: --
2896: end if;
2897: end;
2898: --
2899: -- DK Resolve from Table PER_ABSENCE_ATTENDANCE_TYPES
2900: --
2901: procedure get_dk_frm_aat (p_business_group_name in VARCHAR2
2902: ,p_source_id in NUMBER
2903: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2905: -- cursor to Fetch the DK for PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_ATTENDANCE_TYPE_ID

2901: procedure get_dk_frm_aat (p_business_group_name in VARCHAR2
2902: ,p_source_id in NUMBER
2903: ,p_resolve_mapping_id out nocopy NUMBER) is
2904: --
2905: -- cursor to Fetch the DK for PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_ATTENDANCE_TYPE_ID
2906: --
2907: cursor csr_get_dk_aat is
2908: select name
2909: from per_absence_attendance_types

Line 2909: from per_absence_attendance_types

2905: -- cursor to Fetch the DK for PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_ATTENDANCE_TYPE_ID
2906: --
2907: cursor csr_get_dk_aat is
2908: select name
2909: from per_absence_attendance_types
2910: where absence_attendance_type_id = p_source_id;
2911:
2912: -- Declare local variables
2913: l_proc varchar2(72) := g_package || 'get_dk_frm_aat';

Line 2916: l_table_name varchar2(30) := 'PER_ABSENCE_ATTENDANCE_TYPES';

2912: -- Declare local variables
2913: l_proc varchar2(72) := g_package || 'get_dk_frm_aat';
2914: l_row_fetched boolean := FALSE;
2915: l_table_rec csr_get_dk_aat%rowtype;
2916: l_table_name varchar2(30) := 'PER_ABSENCE_ATTENDANCE_TYPES';
2917: l_column_name varchar2(30) := 'ABSENCE_ATTENDANCE_TYPE_ID';
2918: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2919:
2920: begin