APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CMBN_PLIP_F

Line 461: -- DK Resolve from Table BEN_CMBN_PLIP_F

457: --
458: end if;
459: end;
460: --
461: -- DK Resolve from Table BEN_CMBN_PLIP_F
462: --
463: procedure get_dk_frm_cpl (p_business_group_name in VARCHAR2
464: ,p_source_id in NUMBER
465: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 467: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID

463: procedure get_dk_frm_cpl (p_business_group_name in VARCHAR2
464: ,p_source_id in NUMBER
465: ,p_resolve_mapping_id out nocopy NUMBER) is
466: --
467: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID
468: --
469: cursor csr_get_dk_cpl is
470: select name
471: from ben_cmbn_plip_f

Line 471: from ben_cmbn_plip_f

467: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID
468: --
469: cursor csr_get_dk_cpl is
470: select name
471: from ben_cmbn_plip_f
472: where cmbn_plip_id = p_source_id;
473:
474: -- Declare local variables
475: l_proc varchar2(72) := g_package || 'get_dk_frm_cpl';

Line 478: l_table_name varchar2(30) := 'BEN_CMBN_PLIP_F';

474: -- Declare local variables
475: l_proc varchar2(72) := g_package || 'get_dk_frm_cpl';
476: l_row_fetched boolean := FALSE;
477: l_table_rec csr_get_dk_cpl%rowtype;
478: l_table_name varchar2(30) := 'BEN_CMBN_PLIP_F';
479: l_column_name varchar2(30) := 'CMBN_PLIP_ID';
480: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
481:
482: begin