[Home] [Help]
1737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1738: end;
1739:
1740: --
1741: -- DK Resolve For Table BEN_YR_PERD
1742: --
1743: procedure get_dk_frm_yrp is
1744: --
1745: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID
1741: -- DK Resolve For Table BEN_YR_PERD
1742: --
1743: procedure get_dk_frm_yrp is
1744: --
1745: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID
1746: --
1747: cursor csr_get_dk_yrp (c_business_group_id number, c_source_key varchar2) is
1748: select yr_perd_id
1749: from ben_yr_perd
1745: -- cursor to Fetch the DK for BEN_YR_PERD.YR_PERD_ID
1746: --
1747: cursor csr_get_dk_yrp (c_business_group_id number, c_source_key varchar2) is
1748: select yr_perd_id
1749: from ben_yr_perd
1750: where to_char(END_DATE,'YYYYMMDD:HH24:mi:ss')||'-'||to_char(START_DATE,'DD-MON-YYYY')||'-'||PERD_TYP_CD = c_source_key
1751: and business_group_id = c_business_group_id;
1752:
1753: cursor csr_get_all_yrp is
1752:
1753: cursor csr_get_all_yrp is
1754: select *
1755: from ben_dm_resolve_mappings
1756: where table_name = 'BEN_YR_PERD'
1757: and target_id is null;
1758:
1759: -- Declare local variables
1760: l_proc varchar2(72) := g_package || 'get_dk_frm_yrp';
1765:
1766: begin
1767:
1768: --
1769: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_YR_PERD
1770: --
1771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1772: for x in csr_get_all_yrp loop
1773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3189:
3190: -- DK Resolve for Table BEN_PL_TYP_F
3191: get_dk_frm_ptp;
3192:
3193: -- DK Resolve for Table BEN_YR_PERD
3194: get_dk_frm_yrp;
3195:
3196: -- DK Resolve for Table BEN_LEE_RSN_F
3197: get_dk_frm_len;