APPS.BEN_DM_UPLOAD_DK dependencies on BEN_PL_F

Line 1542: -- DK Resolve For Table BEN_PL_F

1538: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1539: end;
1540:
1541: --
1542: -- DK Resolve For Table BEN_PL_F
1543: --
1544: procedure get_dk_frm_pln is
1545: --
1546: -- cursor to Fetch the DK for BEN_PL_F.PL_ID

Line 1546: -- cursor to Fetch the DK for BEN_PL_F.PL_ID

1542: -- DK Resolve For Table BEN_PL_F
1543: --
1544: procedure get_dk_frm_pln is
1545: --
1546: -- cursor to Fetch the DK for BEN_PL_F.PL_ID
1547: --
1548: cursor csr_get_dk_pln (c_business_group_id number, c_source_key varchar2) is
1549: select pl_id
1550: from ben_pl_f

Line 1550: from ben_pl_f

1546: -- cursor to Fetch the DK for BEN_PL_F.PL_ID
1547: --
1548: cursor csr_get_dk_pln (c_business_group_id number, c_source_key varchar2) is
1549: select pl_id
1550: from ben_pl_f
1551: where name = c_source_key
1552: and business_group_id = c_business_group_id;
1553:
1554: cursor csr_get_all_pln is

Line 1557: where table_name = 'BEN_PL_F'

1553:
1554: cursor csr_get_all_pln is
1555: select *
1556: from ben_dm_resolve_mappings
1557: where table_name = 'BEN_PL_F'
1558: and target_id is null;
1559:
1560: -- Declare local variables
1561: l_proc varchar2(72) := g_package || 'get_dk_frm_pln';

Line 1570: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PL_F

1566:
1567: begin
1568:
1569: --
1570: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PL_F
1571: --
1572: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1573: for x in csr_get_all_pln loop
1574: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3187: -- DK Resolve for Table BEN_PL_F

3183:
3184: -- DK Resolve for Table BEN_PGM_F
3185: get_dk_frm_pgm;
3186:
3187: -- DK Resolve for Table BEN_PL_F
3188: get_dk_frm_pln;
3189:
3190: -- DK Resolve for Table BEN_PL_TYP_F
3191: get_dk_frm_ptp;