APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CMBN_PTIP_OPT_F

Line 591: -- DK Resolve from Table BEN_CMBN_PTIP_OPT_F

587: --
588: end if;
589: end;
590: --
591: -- DK Resolve from Table BEN_CMBN_PTIP_OPT_F
592: --
593: procedure get_dk_frm_cpt (p_business_group_name in VARCHAR2
594: ,p_source_id in NUMBER
595: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 597: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID

593: procedure get_dk_frm_cpt (p_business_group_name in VARCHAR2
594: ,p_source_id in NUMBER
595: ,p_resolve_mapping_id out nocopy NUMBER) is
596: --
597: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID
598: --
599: cursor csr_get_dk_cpt is
600: select name
601: from ben_cmbn_ptip_opt_f

Line 601: from ben_cmbn_ptip_opt_f

597: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID
598: --
599: cursor csr_get_dk_cpt is
600: select name
601: from ben_cmbn_ptip_opt_f
602: where cmbn_ptip_opt_id = p_source_id;
603:
604: -- Declare local variables
605: l_proc varchar2(72) := g_package || 'get_dk_frm_cpt';

Line 608: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_OPT_F';

604: -- Declare local variables
605: l_proc varchar2(72) := g_package || 'get_dk_frm_cpt';
606: l_row_fetched boolean := FALSE;
607: l_table_rec csr_get_dk_cpt%rowtype;
608: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_OPT_F';
609: l_column_name varchar2(30) := 'CMBN_PTIP_OPT_ID';
610: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
611:
612: begin