[Home] [Help]
2722: end loop;
2723: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2724: end;
2725: --
2726: -- DK Resolve For Table PER_ABSENCE_ATTENDANCE_TYPES
2727: --
2728: procedure get_dk_frm_aat is
2729: --
2730: -- cursor to Fetch the DK for PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_ATTENDANCE_TYPE_ID
2726: -- DK Resolve For Table PER_ABSENCE_ATTENDANCE_TYPES
2727: --
2728: procedure get_dk_frm_aat is
2729: --
2730: -- cursor to Fetch the DK for PER_ABSENCE_ATTENDANCE_TYPES.ABSENCE_ATTENDANCE_TYPE_ID
2731: --
2732: cursor csr_get_dk_aat (c_source_key varchar2,
2733: c_business_group_id number) is
2734: select absence_attendance_type_id
2731: --
2732: cursor csr_get_dk_aat (c_source_key varchar2,
2733: c_business_group_id number) is
2734: select absence_attendance_type_id
2735: from per_absence_attendance_types
2736: where name = c_source_key
2737: and business_group_id = c_business_group_id;
2738:
2739: cursor csr_get_all_aat is
2738:
2739: cursor csr_get_all_aat is
2740: select *
2741: from ben_dm_resolve_mappings
2742: where table_name = 'PER_ABSENCE_ATTENDANCE_TYPES'
2743: and target_id is null;
2744:
2745: -- Declare local variables
2746: l_proc varchar2(72) := g_package || 'get_dk_frm_aat';
2751:
2752: begin
2753:
2754: --
2755: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ABSENCE_ATTENDANCE_TYPES
2756: --
2757: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2758: for x in csr_get_all_aat loop
2759: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3260:
3261: -- DK Resolve for Table BEN_OIPLIP_F
3262: get_dk_frm_boi;
3263:
3264: -- DK Resolve for Table PER_ABSENCE_ATTENDANCE_TYPES
3265: get_dk_frm_aat;
3266:
3267: -- DK Resolve for Table PER_ABS_ATTENDANCE_REASONS
3268: get_dk_frm_aar;