[Home] [Help]
1601: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1602: end;
1603:
1604: --
1605: -- DK Resolve For Table BEN_PL_TYP_F
1606: --
1607: procedure get_dk_frm_ptp is
1608: --
1609: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID
1605: -- DK Resolve For Table BEN_PL_TYP_F
1606: --
1607: procedure get_dk_frm_ptp is
1608: --
1609: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID
1610: --
1611: cursor csr_get_dk_ptp (c_business_group_id number, c_source_key varchar2) is
1612: select pl_typ_id
1613: from ben_pl_typ_f
1609: -- cursor to Fetch the DK for BEN_PL_TYP_F.PL_TYP_ID
1610: --
1611: cursor csr_get_dk_ptp (c_business_group_id number, c_source_key varchar2) is
1612: select pl_typ_id
1613: from ben_pl_typ_f
1614: where name = c_source_key
1615: and business_group_id = c_business_group_id;
1616:
1617: cursor csr_get_all_ptp is
1616:
1617: cursor csr_get_all_ptp is
1618: select *
1619: from ben_dm_resolve_mappings
1620: where table_name = 'BEN_PL_TYP_F'
1621: and target_id is null;
1622:
1623: -- Declare local variables
1624: l_proc varchar2(72) := g_package || 'get_dk_frm_ptp';
1629:
1630: begin
1631:
1632: --
1633: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PL_TYP_F
1634: --
1635: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1636: for x in csr_get_all_ptp loop
1637: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3186:
3187: -- DK Resolve for Table BEN_PL_F
3188: get_dk_frm_pln;
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;