[Home] [Help]
927: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
928: end;
929:
930: --
931: -- DK Resolve For Table BEN_ENRT_PERD
932: --
933: procedure get_dk_frm_enp is
934: --
935: -- cursor to Fetch the DK for BEN_ENRT_PERD.ENRT_PERD_ID
931: -- DK Resolve For Table BEN_ENRT_PERD
932: --
933: procedure get_dk_frm_enp is
934: --
935: -- cursor to Fetch the DK for BEN_ENRT_PERD.ENRT_PERD_ID
936: --
937: cursor csr_get_dk_enp (c_business_group_id number, c_source_key varchar2
938: ,c_target_id1 number, c_target_id2 number) is
939: select enrt_perd_id
936: --
937: cursor csr_get_dk_enp (c_business_group_id number, c_source_key varchar2
938: ,c_target_id1 number, c_target_id2 number) is
939: select enrt_perd_id
940: from ben_enrt_perd
941: where strt_dt = to_date(c_source_key,'dd-mm-rrrr')
942: and yr_perd_id = c_target_id1
943: and popl_enrt_typ_cycl_id = c_target_id2
944: and business_group_id = c_business_group_id
946:
947: cursor csr_get_all_enp is
948: select *
949: from ben_dm_resolve_mappings
950: where table_name = 'BEN_ENRT_PERD'
951: and target_id is null;
952:
953: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
954: select *
971:
972: begin
973:
974: --
975: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ENRT_PERD
976: --
977: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
978: for x in csr_get_all_enp loop
979: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1072:
1073: begin
1074:
1075: --
1076: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ENRT_PERD
1077: --
1078: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1079: for x in csr_get_all_len loop
1080: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3245:
3246: -- DK Resolve for Table PAY_PEOPLE_GROUPS
3247: get_dk_frm_peg;
3248:
3249: -- DK Resolve for Table BEN_ENRT_PERD
3250: get_dk_frm_enp;
3251:
3252: -- DK Resolve for Table BEN_OIPL_F
3253: get_dk_frm_cop;