[Home] [Help]
2185: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2186: end;
2187:
2188: --
2189: -- DK Resolve For Table PAY_ALL_PAYROLLS_F
2190: --
2191: procedure get_dk_frm_prl is
2192: --
2193: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID
2189: -- DK Resolve For Table PAY_ALL_PAYROLLS_F
2190: --
2191: procedure get_dk_frm_prl is
2192: --
2193: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID
2194: --
2195: cursor csr_get_dk_prl (c_business_group_id number, c_source_key varchar2) is
2196: select payroll_id
2197: from pay_all_payrolls_f
2193: -- cursor to Fetch the DK for PAY_ALL_PAYROLLS_F.PAYROLL_ID
2194: --
2195: cursor csr_get_dk_prl (c_business_group_id number, c_source_key varchar2) is
2196: select payroll_id
2197: from pay_all_payrolls_f
2198: where payroll_name = c_source_key
2199: and business_group_id = c_business_group_id;
2200:
2201: cursor csr_get_all_prl is
2200:
2201: cursor csr_get_all_prl is
2202: select *
2203: from ben_dm_resolve_mappings
2204: where table_name = 'PAY_ALL_PAYROLLS_F'
2205: and target_id is null;
2206:
2207: -- Declare local variables
2208: l_proc varchar2(72) := g_package || 'get_dk_frm_prl';
2213:
2214: begin
2215:
2216: --
2217: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ALL_PAYROLLS_F
2218: --
2219: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2220: for x in csr_get_all_prl loop
2221: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3212:
3213: -- DK Resolve for Table HR_LOCATIONS_ALL
3214: get_dk_frm_loc;
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;