APPS.BEN_DM_UPLOAD_DK dependencies on BEN_BENFTS_GRP

Line 228: -- DK Resolve For Table BEN_BENFTS_GRP

224: end loop;
225: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
226: end;
227: --
228: -- DK Resolve For Table BEN_BENFTS_GRP
229: --
230: procedure get_dk_frm_bng is
231: --
232: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID

Line 232: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID

228: -- DK Resolve For Table BEN_BENFTS_GRP
229: --
230: procedure get_dk_frm_bng is
231: --
232: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID
233: --
234: cursor csr_get_dk_bng (c_business_group_id number, c_source_key varchar2) is
235: select benfts_grp_id
236: from ben_benfts_grp

Line 236: from ben_benfts_grp

232: -- cursor to Fetch the DK for BEN_BENFTS_GRP.BENFTS_GRP_ID
233: --
234: cursor csr_get_dk_bng (c_business_group_id number, c_source_key varchar2) is
235: select benfts_grp_id
236: from ben_benfts_grp
237: where name = c_source_key
238: ;
239:
240: cursor csr_get_all_bng is

Line 243: where table_name = 'BEN_BENFTS_GRP'

239:
240: cursor csr_get_all_bng is
241: select *
242: from ben_dm_resolve_mappings
243: where table_name = 'BEN_BENFTS_GRP'
244: and target_id is null;
245:
246: -- Declare local variables
247: l_proc varchar2(72) := g_package || 'get_dk_frm_bng';

Line 256: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BENFTS_GRP

252:
253: begin
254:
255: --
256: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BENFTS_GRP
257: --
258: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
259: for x in csr_get_all_bng loop
260: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3148: -- DK Resolve for Table BEN_BENFTS_GRP

3144:
3145: -- DK Resolve for Table BEN_ACTY_BASE_RT_F
3146: get_dk_frm_abr;
3147:
3148: -- DK Resolve for Table BEN_BENFTS_GRP
3149: get_dk_frm_bng;
3150:
3151: -- DK Resolve for Table BEN_BNFTS_BAL_F
3152: get_dk_frm_bnb;