[Home] [Help]
287: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
288: end;
289:
290: --
291: -- DK Resolve For Table PAY_ELEMENT_LINKS_F
292: --
293: procedure get_dk_frm_pll is
294: --
295: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID
291: -- DK Resolve For Table PAY_ELEMENT_LINKS_F
292: --
293: procedure get_dk_frm_pll is
294: --
295: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID
296: --
297: cursor csr_get_dk_pll (c_business_group_id number, c_source_id number) is
298: select element_Link_id
299: from pay_element_links_f
295: -- cursor to Fetch the DK for PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID
296: --
297: cursor csr_get_dk_pll (c_business_group_id number, c_source_id number) is
298: select element_Link_id
299: from pay_element_links_f
300: where element_type_id = c_source_id
301: and business_group_id = c_business_group_id;
302:
303: cursor csr_get_all_pll is
302:
303: cursor csr_get_all_pll is
304: select *
305: from ben_dm_resolve_mappings
306: where table_name = 'PAY_ELEMENT_LINKS_F'
307: and target_id is null;
308:
309: -- Declare local variables
310: l_proc varchar2(72) := g_package || 'get_dk_frm_pll';
316:
317: begin
318:
319: --
320: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ELEMENT_LINKS_F
321: --
322: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
323: for x in csr_get_all_pll loop
324: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3221:
3222: -- DK Resolve for Table PAY_INPUT_VALUES_F
3223: get_dk_frm_ipv;
3224:
3225: -- DK Resolve for Table PAY_ELEMENT_LINKS_F
3226: get_dk_frm_pll;
3227:
3228: -- DK Resolve for Table PER_ASSIGNMENT_STATUS_TYPES
3229: get_dk_frm_ast;