APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_COMP_LVL_FCTR

Line 786: -- DK Resolve from Table BEN_COMP_LVL_FCTR

782: --
783: end if;
784: end;
785: --
786: -- DK Resolve from Table BEN_COMP_LVL_FCTR
787: --
788: procedure get_dk_frm_clf (p_business_group_name in VARCHAR2
789: ,p_source_id in NUMBER
790: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 792: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID

788: procedure get_dk_frm_clf (p_business_group_name in VARCHAR2
789: ,p_source_id in NUMBER
790: ,p_resolve_mapping_id out nocopy NUMBER) is
791: --
792: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID
793: --
794: cursor csr_get_dk_clf is
795: select name
796: from ben_comp_lvl_fctr

Line 796: from ben_comp_lvl_fctr

792: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID
793: --
794: cursor csr_get_dk_clf is
795: select name
796: from ben_comp_lvl_fctr
797: where comp_lvl_fctr_id = p_source_id;
798:
799: -- Declare local variables
800: l_proc varchar2(72) := g_package || 'get_dk_frm_clf';

Line 803: l_table_name varchar2(30) := 'BEN_COMP_LVL_FCTR';

799: -- Declare local variables
800: l_proc varchar2(72) := g_package || 'get_dk_frm_clf';
801: l_row_fetched boolean := FALSE;
802: l_table_rec csr_get_dk_clf%rowtype;
803: l_table_name varchar2(30) := 'BEN_COMP_LVL_FCTR';
804: l_column_name varchar2(30) := 'COMP_LVL_FCTR_ID';
805: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
806:
807: begin