[Home] [Help]
2312: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2313: end;
2314:
2315: --
2316: -- DK Resolve For Table PAY_INPUT_VALUES_F
2317: --
2318: procedure get_dk_frm_ipv is
2319: --
2320: -- cursor to Fetch the DK for PAY_INPUT_VALUES_F.INPUT_VALUE_ID
2316: -- DK Resolve For Table PAY_INPUT_VALUES_F
2317: --
2318: procedure get_dk_frm_ipv is
2319: --
2320: -- cursor to Fetch the DK for PAY_INPUT_VALUES_F.INPUT_VALUE_ID
2321: --
2322: cursor csr_get_dk_ipv (c_business_group_id number, c_source_key varchar2
2323: ,c_target_id1 number) is
2324: select input_value_id
2321: --
2322: cursor csr_get_dk_ipv (c_business_group_id number, c_source_key varchar2
2323: ,c_target_id1 number) is
2324: select input_value_id
2325: from pay_input_values_f
2326: where name = c_source_key
2327: and element_type_id = c_target_id1
2328: and (business_group_id = c_business_group_id or business_group_id is null)
2329: and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
2330:
2331: cursor csr_get_all_ipv is
2332: select *
2333: from ben_dm_resolve_mappings
2334: where table_name = 'PAY_INPUT_VALUES_F'
2335: and target_id is null;
2336:
2337: -- Declare local variables
2338: l_proc varchar2(72) := g_package || 'get_dk_frm_ipv';
2345:
2346: begin
2347:
2348: --
2349: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_INPUT_VALUES_F
2350: --
2351: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2352: for x in csr_get_all_ipv loop
2353: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3218:
3219: -- DK Resolve for Table PAY_ELEMENT_TYPES_F
3220: get_dk_frm_pet;
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;