[Home] [Help]
2248: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2249: end;
2250:
2251: --
2252: -- DK Resolve For Table PAY_ELEMENT_TYPES_F
2253: --
2254: procedure get_dk_frm_pet is
2255: --
2256: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID
2252: -- DK Resolve For Table PAY_ELEMENT_TYPES_F
2253: --
2254: procedure get_dk_frm_pet is
2255: --
2256: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID
2257: --
2258: cursor csr_get_dk_pet (c_business_group_id number, c_source_key varchar2) is
2259: select element_type_id
2260: from pay_element_types_f
2256: -- cursor to Fetch the DK for PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID
2257: --
2258: cursor csr_get_dk_pet (c_business_group_id number, c_source_key varchar2) is
2259: select element_type_id
2260: from pay_element_types_f
2261: where element_name = c_source_key
2262: and (business_group_id = c_business_group_id or business_group_id is null)
2263: and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
2264:
2264:
2265: cursor csr_get_all_pet is
2266: select *
2267: from ben_dm_resolve_mappings
2268: where table_name = 'PAY_ELEMENT_TYPES_F'
2269: and target_id is null;
2270:
2271: -- Declare local variables
2272: l_proc varchar2(72) := g_package || 'get_dk_frm_pet';
2277:
2278: begin
2279:
2280: --
2281: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ELEMENT_TYPES_F
2282: --
2283: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2284: for x in csr_get_all_pet loop
2285: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3215:
3216: -- DK Resolve for Table PAY_ALL_PAYROLLS_F
3217: get_dk_frm_prl;
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;