APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_BNFT_PRVDR_POOL_F

Line 396: -- DK Resolve from Table BEN_BNFT_PRVDR_POOL_F

392: end if;
393: end;
394:
395: --
396: -- DK Resolve from Table BEN_BNFT_PRVDR_POOL_F
397: --
398: procedure get_dk_frm_bpp (p_business_group_name in VARCHAR2
399: ,p_source_id in NUMBER
400: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 402: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID

398: procedure get_dk_frm_bpp (p_business_group_name in VARCHAR2
399: ,p_source_id in NUMBER
400: ,p_resolve_mapping_id out nocopy NUMBER) is
401: --
402: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID
403: --
404: cursor csr_get_dk_bpp is
405: select name
406: from ben_bnft_prvdr_pool_f

Line 406: from ben_bnft_prvdr_pool_f

402: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID
403: --
404: cursor csr_get_dk_bpp is
405: select name
406: from ben_bnft_prvdr_pool_f
407: where bnft_prvdr_pool_id = p_source_id;
408:
409: -- Declare local variables
410: l_proc varchar2(72) := g_package || 'get_dk_frm_bpp';

Line 413: l_table_name varchar2(30) := 'BEN_BNFT_PRVDR_POOL_F';

409: -- Declare local variables
410: l_proc varchar2(72) := g_package || 'get_dk_frm_bpp';
411: l_row_fetched boolean := FALSE;
412: l_table_rec csr_get_dk_bpp%rowtype;
413: l_table_name varchar2(30) := 'BEN_BNFT_PRVDR_POOL_F';
414: l_column_name varchar2(30) := 'BNFT_PRVDR_POOL_ID';
415: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
416:
417: begin