APPS.BEN_DM_UPLOAD_DK dependencies on BEN_OPT_F

Line 1343: -- DK Resolve For Table BEN_OPT_F

1339: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1340: end;
1341:
1342: --
1343: -- DK Resolve For Table BEN_OPT_F
1344: --
1345: procedure get_dk_frm_opt is
1346: --
1347: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID

Line 1347: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID

1343: -- DK Resolve For Table BEN_OPT_F
1344: --
1345: procedure get_dk_frm_opt is
1346: --
1347: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID
1348: --
1349: cursor csr_get_dk_opt (c_business_group_id number, c_source_key varchar2) is
1350: select opt_id
1351: from ben_opt_f

Line 1351: from ben_opt_f

1347: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID
1348: --
1349: cursor csr_get_dk_opt (c_business_group_id number, c_source_key varchar2) is
1350: select opt_id
1351: from ben_opt_f
1352: where name = c_source_key
1353: and business_group_id = c_business_group_id;
1354:
1355: cursor csr_get_all_opt is

Line 1358: where table_name = 'BEN_OPT_F'

1354:
1355: cursor csr_get_all_opt is
1356: select *
1357: from ben_dm_resolve_mappings
1358: where table_name = 'BEN_OPT_F'
1359: and target_id is null;
1360:
1361: -- Declare local variables
1362: l_proc varchar2(72) := g_package || 'get_dk_frm_opt';

Line 1371: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OPT_F

1367:
1368: begin
1369:
1370: --
1371: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OPT_F
1372: --
1373: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1374: for x in csr_get_all_opt loop
1375: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3181: -- DK Resolve for Table BEN_OPT_F

3177:
3178: -- DK Resolve for Table BEN_LER_F
3179: get_dk_frm_ler;
3180:
3181: -- DK Resolve for Table BEN_OPT_F
3182: get_dk_frm_opt;
3183:
3184: -- DK Resolve for Table BEN_PGM_F
3185: get_dk_frm_pgm;