[Home] [Help]
1664: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1665: end;
1666:
1667: --
1668: -- DK Resolve For Table BEN_PTIP_F
1669: --
1670: procedure get_dk_frm_ctp is
1671: --
1672: -- cursor to Fetch the DK for BEN_PTIP_F.PTIP_ID
1668: -- DK Resolve For Table BEN_PTIP_F
1669: --
1670: procedure get_dk_frm_ctp is
1671: --
1672: -- cursor to Fetch the DK for BEN_PTIP_F.PTIP_ID
1673: --
1674: cursor csr_get_dk_ctp (c_business_group_id number, c_source_key varchar2
1675: ,c_target_id1 number, c_target_id2 number) is
1676: select ptip_id
1673: --
1674: cursor csr_get_dk_ctp (c_business_group_id number, c_source_key varchar2
1675: ,c_target_id1 number, c_target_id2 number) is
1676: select ptip_id
1677: from ben_ptip_f
1678: where pgm_id = c_target_id1
1679: and pl_typ_id = c_target_id2
1680: and business_group_id = c_business_group_id;
1681:
1681:
1682: cursor csr_get_all_ctp is
1683: select *
1684: from ben_dm_resolve_mappings
1685: where table_name = 'BEN_PTIP_F'
1686: and target_id is null;
1687:
1688: -- Declare local variables
1689: l_proc varchar2(72) := g_package || 'get_dk_frm_ctp';
1696:
1697: begin
1698:
1699: --
1700: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PTIP_F
1701: --
1702: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1703: for x in csr_get_all_ctp loop
1704: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3254:
3255: -- DK Resolve for Table BEN_PLIP_F
3256: get_dk_frm_cpp;
3257:
3258: -- DK Resolve for Table BEN_PTIP_F
3259: get_dk_frm_ctp;
3260:
3261: -- DK Resolve for Table BEN_OIPLIP_F
3262: get_dk_frm_boi;