APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_ACTY_BASE_RT_F

Line 200: -- DK Resolve from Table BEN_ACTY_BASE_RT_F

196: --
197: end if;
198: end;
199: --
200: -- DK Resolve from Table BEN_ACTY_BASE_RT_F
201: --
202: procedure get_dk_frm_abr (p_business_group_name in VARCHAR2
203: ,p_source_id in NUMBER
204: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 206: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID

202: procedure get_dk_frm_abr (p_business_group_name in VARCHAR2
203: ,p_source_id in NUMBER
204: ,p_resolve_mapping_id out nocopy NUMBER) is
205: --
206: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID
207: --
208: cursor csr_get_dk_abr is
209: select name
210: from ben_acty_base_rt_f

Line 210: from ben_acty_base_rt_f

206: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID
207: --
208: cursor csr_get_dk_abr is
209: select name
210: from ben_acty_base_rt_f
211: where acty_base_rt_id = p_source_id;
212:
213: -- Declare local variables
214: l_proc varchar2(72) := g_package || 'get_dk_frm_abr';

Line 217: l_table_name varchar2(30) := 'BEN_ACTY_BASE_RT_F';

213: -- Declare local variables
214: l_proc varchar2(72) := g_package || 'get_dk_frm_abr';
215: l_row_fetched boolean := FALSE;
216: l_table_rec csr_get_dk_abr%rowtype;
217: l_table_name varchar2(30) := 'BEN_ACTY_BASE_RT_F';
218: l_column_name varchar2(30) := 'ACTY_BASE_RT_ID';
219: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
220:
221: begin