APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 851: -- DK Resolve from Table BEN_CVG_AMT_CALC_MTHD_F

847: --
848: end if;
849: end;
850: --
851: -- DK Resolve from Table BEN_CVG_AMT_CALC_MTHD_F
852: --
853: procedure get_dk_frm_ccm (p_business_group_name in VARCHAR2
854: ,p_source_id in NUMBER
855: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 857: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID

853: procedure get_dk_frm_ccm (p_business_group_name in VARCHAR2
854: ,p_source_id in NUMBER
855: ,p_resolve_mapping_id out nocopy NUMBER) is
856: --
857: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID
858: --
859: cursor csr_get_dk_ccm is
860: select name
861: from ben_cvg_amt_calc_mthd_f

Line 861: from ben_cvg_amt_calc_mthd_f

857: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID
858: --
859: cursor csr_get_dk_ccm is
860: select name
861: from ben_cvg_amt_calc_mthd_f
862: where cvg_amt_calc_mthd_id = p_source_id;
863:
864: -- Declare local variables
865: l_proc varchar2(72) := g_package || 'get_dk_frm_ccm';

Line 868: l_table_name varchar2(30) := 'BEN_CVG_AMT_CALC_MTHD_F';

864: -- Declare local variables
865: l_proc varchar2(72) := g_package || 'get_dk_frm_ccm';
866: l_row_fetched boolean := FALSE;
867: l_table_rec csr_get_dk_ccm%rowtype;
868: l_table_name varchar2(30) := 'BEN_CVG_AMT_CALC_MTHD_F';
869: l_column_name varchar2(30) := 'CVG_AMT_CALC_MTHD_ID';
870: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
871:
872: begin