APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_BENFTS_GRP

Line 265: -- DK Resolve from Table BEN_BENFTS_GRP

261: --
262: end if;
263: end;
264: --
265: -- DK Resolve from Table BEN_BENFTS_GRP
266: --
267: procedure get_dk_frm_bng (p_business_group_name in VARCHAR2
268: ,p_source_id in NUMBER
269: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 271: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID

267: procedure get_dk_frm_bng (p_business_group_name in VARCHAR2
268: ,p_source_id in NUMBER
269: ,p_resolve_mapping_id out nocopy NUMBER) is
270: --
271: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID
272: --
273: cursor csr_get_dk_bng is
274: select name
275: from ben_benfts_grp

Line 275: from ben_benfts_grp

271: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID
272: --
273: cursor csr_get_dk_bng is
274: select name
275: from ben_benfts_grp
276: where benfts_grp_id = p_source_id;
277:
278: -- Declare local variables
279: l_proc varchar2(72) := g_package || 'get_dk_frm_bng';

Line 282: l_table_name varchar2(30) := 'BEN_BENFTS_GRP';

278: -- Declare local variables
279: l_proc varchar2(72) := g_package || 'get_dk_frm_bng';
280: l_row_fetched boolean := FALSE;
281: l_table_rec csr_get_dk_bng%rowtype;
282: l_table_name varchar2(30) := 'BEN_BENFTS_GRP';
283: l_column_name varchar2(30) := 'BENFTS_GRP_ID';
284: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
285:
286: begin