[Home] [Help]
2384: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2385: end;
2386:
2387: --
2388: -- DK Resolve For Table PER_ASSIGNMENT_STATUS_TYPES
2389: --
2390: procedure get_dk_frm_ast is
2391: --
2392: -- cursor to Fetch the DK for PER_ASSIGNMENT_STATUS_TYPES.ASSIGNMENT_STATUS_TYPE_ID
2388: -- DK Resolve For Table PER_ASSIGNMENT_STATUS_TYPES
2389: --
2390: procedure get_dk_frm_ast is
2391: --
2392: -- cursor to Fetch the DK for PER_ASSIGNMENT_STATUS_TYPES.ASSIGNMENT_STATUS_TYPE_ID
2393: --
2394: cursor csr_get_dk_ast (c_user_status varchar2,
2395: c_leg_code varchar2,
2396: c_bg_id number) is
2394: cursor csr_get_dk_ast (c_user_status varchar2,
2395: c_leg_code varchar2,
2396: c_bg_id number) is
2397: select assignment_status_type_id
2398: from per_assignment_status_types
2399: where user_status = c_user_status
2400: and nvl(legislation_code,'-x') = c_leg_code
2401: and nvl(business_group_id,-1) = nvl(c_bg_id,-1) ;
2402:
2402:
2403: cursor csr_get_all_ast is
2404: select *
2405: from ben_dm_resolve_mappings
2406: where table_name = 'PER_ASSIGNMENT_STATUS_TYPES'
2407: and target_id is null;
2408:
2409: -- Declare local variables
2410: l_proc varchar2(72) := g_package || 'get_dk_frm_ast';
2420:
2421: begin
2422:
2423: --
2424: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ASSIGNMENT_STATUS_TYPES
2425: --
2426: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2427: for x in csr_get_all_ast loop
2428: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
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;
3230:
3231: -- DK Resolve for Table PER_GRADES
3232: get_dk_frm_gra;