[Home] [Help]
2660: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2661: end;
2662:
2663: --
2664: -- DK Resolve For Table PER_PERSON_TYPES
2665: --
2666: procedure get_dk_frm_prt is
2667: --
2668: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID
2664: -- DK Resolve For Table PER_PERSON_TYPES
2665: --
2666: procedure get_dk_frm_prt is
2667: --
2668: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID
2669: --
2670: cursor csr_get_dk_prt (c_business_group_id number, c_source_key varchar2) is
2671: select person_type_id
2672: from per_person_types
2668: -- cursor to Fetch the DK for PER_PERSON_TYPES.PERSON_TYPE_ID
2669: --
2670: cursor csr_get_dk_prt (c_business_group_id number, c_source_key varchar2) is
2671: select person_type_id
2672: from per_person_types
2673: where user_person_type = c_source_key
2674: and business_group_id = c_business_group_id ;
2675:
2676: cursor csr_get_all_prt is
2675:
2676: cursor csr_get_all_prt is
2677: select *
2678: from ben_dm_resolve_mappings
2679: where table_name = 'PER_PERSON_TYPES'
2680: and target_id is null;
2681:
2682: -- Declare local variables
2683: l_proc varchar2(72) := g_package || 'get_dk_frm_prt';
2688:
2689: begin
2690:
2691: --
2692: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_PERSON_TYPES
2693: --
2694: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2695: for x in csr_get_all_prt loop
2696: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3236:
3237: -- DK Resolve for Table PER_PAY_BASES
3238: get_dk_frm_pyb;
3239:
3240: -- DK Resolve for Table PER_PERSON_TYPES
3241: get_dk_frm_prt;
3242:
3243: -- DK Resolve for Table HR_SOFT_CODING_KEYFLEX
3244: get_dk_frm_scl;