1195: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1196: end;
1197:
1198: --
1199: -- DK Resolve For Table BEN_OIPLIP_F
1200: --
1201: procedure get_dk_frm_boi is
1202: --
1203: -- cursor to Fetch the DK for BEN_OIPLIP_F.OIPLIP_ID
1199: -- DK Resolve For Table BEN_OIPLIP_F
1200: --
1201: procedure get_dk_frm_boi is
1202: --
1203: -- cursor to Fetch the DK for BEN_OIPLIP_F.OIPLIP_ID
1204: --
1205: cursor csr_get_dk_boi (c_business_group_id number, c_source_key varchar2
1206: ,c_target_id1 number, c_target_id2 number) is
1207: select oiplip_id
1204: --
1205: cursor csr_get_dk_boi (c_business_group_id number, c_source_key varchar2
1206: ,c_target_id1 number, c_target_id2 number) is
1207: select oiplip_id
1208: from ben_oiplip_f
1209: where oipl_id = c_target_id1
1210: and plip_id = c_target_id2;
1211:
1212: cursor csr_get_all_boi is
1211:
1212: cursor csr_get_all_boi is
1213: select *
1214: from ben_dm_resolve_mappings
1215: where table_name = 'BEN_OIPLIP_F'
1216: and target_id is null;
1217:
1218: -- Declare local variables
1219: l_proc varchar2(72) := g_package || 'get_dk_frm_boi';
1226:
1227: begin
1228:
1229: --
1230: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OIPLIP_F
1231: --
1232: for x in csr_get_all_boi loop
1233: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1234: -- Get OIPL_ID
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;
3263:
3264: -- DK Resolve for Table PER_ABSENCE_ATTENDANCE_TYPES
3265: get_dk_frm_aat;