APPS.BEN_DM_UPLOAD_DK dependencies on BEN_ACTL_PREM_F

Line 29: -- DK Resolve for Table BEN_ACTL_PREM_F

25:
26: end;
27:
28: --
29: -- DK Resolve for Table BEN_ACTL_PREM_F
30: --
31: procedure get_dk_frm_apr is
32:
33: --

Line 34: -- cursor to Fetch the DK for BEN_ACTL_PREM_F.ACTL_PREM_ID.

30: --
31: procedure get_dk_frm_apr is
32:
33: --
34: -- cursor to Fetch the DK for BEN_ACTL_PREM_F.ACTL_PREM_ID.
35: --
36:
37: cursor csr_get_dk_apr (c_business_group_id number, c_source_key varchar2) is
38: select actl_prem_id

Line 39: from ben_actl_prem_f apr

35: --
36:
37: cursor csr_get_dk_apr (c_business_group_id number, c_source_key varchar2) is
38: select actl_prem_id
39: from ben_actl_prem_f apr
40: where business_group_id = c_business_group_id
41: and name = c_source_key;
42:
43: cursor csr_get_all_apr is

Line 46: where table_name = 'BEN_ACTL_PREM_F'

42:
43: cursor csr_get_all_apr is
44: select *
45: from ben_dm_resolve_mappings cm
46: where table_name = 'BEN_ACTL_PREM_F'
47: and target_id is null;
48:
49: -- Declare local variables
50: l_proc varchar2(72) := g_package || 'get_dk_frm_apr' ;

Line 58: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTL_PREM_F.

54: l_bg_id number;
55:
56: begin
57: --
58: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTL_PREM_F.
59: --
60: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
61: for x in csr_get_all_apr loop
62:

Line 3139: -- DK Resolve for Table BEN_ACTL_PREM_F

3135: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
3136:
3137: hr_general.g_data_migrator_mode := 'Y';
3138:
3139: -- DK Resolve for Table BEN_ACTL_PREM_F
3140: get_dk_frm_apr;
3141:
3142: -- DK Resolve for Table BEN_ACTN_TYP
3143: get_dk_frm_eat;