APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_ENRT_PERD

Line 916: -- DK Resolve from Table BEN_ENRT_PERD

912: --
913: end if;
914: end;
915: --
916: -- DK Resolve from Table BEN_ENRT_PERD
917: --
918: procedure get_dk_frm_enp (p_business_group_name in VARCHAR2
919: ,p_source_id in NUMBER
920: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 922: -- cursor to Fetch the DK for BEN_ENRT_PERD.ENRT_PERD_ID

918: procedure get_dk_frm_enp (p_business_group_name in VARCHAR2
919: ,p_source_id in NUMBER
920: ,p_resolve_mapping_id out nocopy NUMBER) is
921: --
922: -- cursor to Fetch the DK for BEN_ENRT_PERD.ENRT_PERD_ID
923: --
924: cursor csr_get_dk_enp is
925: select *
926: from ben_enrt_perd

Line 926: from ben_enrt_perd

922: -- cursor to Fetch the DK for BEN_ENRT_PERD.ENRT_PERD_ID
923: --
924: cursor csr_get_dk_enp is
925: select *
926: from ben_enrt_perd
927: where enrt_perd_id = p_source_id;
928:
929: --
930: -- cursor to Fetch the DK for POPL_ENRT_TYP_CYCL_F.POPL_ENRT_TYP_CYCL_ID

Line 943: l_table_name varchar2(30) := 'BEN_ENRT_PERD';

939: l_row_fetched boolean := FALSE;
940: l_row_fetched_pop boolean := FALSE;
941: l_table_rec csr_get_dk_enp%rowtype;
942: l_table_rec_pop csr_get_dk_pop%rowtype;
943: l_table_name varchar2(30) := 'BEN_ENRT_PERD';
944: l_column_name varchar2(30) := 'ENRT_PERD_ID';
945: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
946: l_yr_perd_id number;
947: l_popl_enrt_typ_cycl_id number;