APPS.BEN_DM_UPLOAD_DK dependencies on BEN_ACTN_TYP

Line 96: -- DK Resolve For Table BEN_ACTN_TYP

92: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
93:
94: end;
95: --
96: -- DK Resolve For Table BEN_ACTN_TYP
97: --
98: procedure get_dk_frm_eat is
99: --
100: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID

Line 100: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID

96: -- DK Resolve For Table BEN_ACTN_TYP
97: --
98: procedure get_dk_frm_eat is
99: --
100: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID
101: --
102: cursor csr_get_dk_eat (c_business_group_id number, c_source_key varchar2) is
103: select actn_typ_id
104: from ben_actn_typ

Line 104: from ben_actn_typ

100: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID
101: --
102: cursor csr_get_dk_eat (c_business_group_id number, c_source_key varchar2) is
103: select actn_typ_id
104: from ben_actn_typ
105: where name = c_source_key
106: and business_group_id = c_business_group_id
107: ;
108:

Line 112: where table_name = 'BEN_ACTN_TYP'

108:
109: cursor csr_get_all_eat is
110: select *
111: from ben_dm_resolve_mappings
112: where table_name = 'BEN_ACTN_TYP'
113: and target_id is null;
114:
115: -- Declare local variables
116: l_proc varchar2(72) := g_package || 'get_dk_frm_eat';

Line 125: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTN_TYP

121:
122: begin
123:
124: --
125: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTN_TYP
126: --
127: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
128: for x in csr_get_all_eat loop
129:

Line 3142: -- DK Resolve for Table BEN_ACTN_TYP

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;
3144:
3145: -- DK Resolve for Table BEN_ACTY_BASE_RT_F
3146: get_dk_frm_abr;