APPS.BEN_DM_DOWNLOAD_DK dependencies on PER_ABS_ATTENDANCE_REASONS

Line 2975: -- DK Resolve from Table PER_ABS_ATTENDANCE_REASONS

2971: --
2972: end if;
2973: end;
2974: --
2975: -- DK Resolve from Table PER_ABS_ATTENDANCE_REASONS
2976: --
2977: procedure get_dk_frm_aar (p_business_group_name in VARCHAR2
2978: ,p_source_id in NUMBER
2979: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2981: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID

2977: procedure get_dk_frm_aar (p_business_group_name in VARCHAR2
2978: ,p_source_id in NUMBER
2979: ,p_resolve_mapping_id out nocopy NUMBER) is
2980: --
2981: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID
2982: --
2983: cursor csr_get_dk_aar is
2984: select *
2985: from per_abs_attendance_reasons

Line 2985: from per_abs_attendance_reasons

2981: -- cursor to Fetch the DK for PER_ABS_ATTENDANCE_REASONS.ABS_ATTENDANCE_REASON_ID
2982: --
2983: cursor csr_get_dk_aar is
2984: select *
2985: from per_abs_attendance_reasons
2986: where abs_attendance_reason_id = p_source_id;
2987:
2988: -- Declare local variables
2989: l_proc varchar2(72) := g_package || 'get_dk_frm_aar';

Line 2992: l_table_name varchar2(30) := 'PER_ABS_ATTENDANCE_REASONS';

2988: -- Declare local variables
2989: l_proc varchar2(72) := g_package || 'get_dk_frm_aar';
2990: l_row_fetched boolean := FALSE;
2991: l_table_rec csr_get_dk_aar%rowtype;
2992: l_table_name varchar2(30) := 'PER_ABS_ATTENDANCE_REASONS';
2993: l_column_name varchar2(30) := 'ABS_ATTENDANCE_REASON_ID';
2994: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2995: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2996: