APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_PL_F

Line 1635: -- DK Resolve from Table BEN_PL_F

1631: ,p_business_group_name => p_business_group_name);
1632: end if;
1633: end;
1634: --
1635: -- DK Resolve from Table BEN_PL_F
1636: --
1637: procedure get_dk_frm_pln (p_business_group_name in VARCHAR2
1638: ,p_source_id in NUMBER
1639: ,p_resolve_mapping_id out nocopy NUMBER) is

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

1637: procedure get_dk_frm_pln (p_business_group_name in VARCHAR2
1638: ,p_source_id in NUMBER
1639: ,p_resolve_mapping_id out nocopy NUMBER) is
1640: --
1641: -- cursor to Fetch the DK for BEN_PL_F.PL_ID
1642: --
1643: cursor csr_get_dk_pln is
1644: select name
1645: from ben_pl_f

Line 1645: from ben_pl_f

1641: -- cursor to Fetch the DK for BEN_PL_F.PL_ID
1642: --
1643: cursor csr_get_dk_pln is
1644: select name
1645: from ben_pl_f
1646: where pl_id = p_source_id;
1647:
1648: -- Declare local variables
1649: l_proc varchar2(72) := g_package || 'get_dk_frm_pln';

Line 1652: l_table_name varchar2(30) := 'BEN_PL_F';

1648: -- Declare local variables
1649: l_proc varchar2(72) := g_package || 'get_dk_frm_pln';
1650: l_row_fetched boolean := FALSE;
1651: l_table_rec csr_get_dk_pln%rowtype;
1652: l_table_name varchar2(30) := 'BEN_PL_F';
1653: l_column_name varchar2(30) := 'PL_ID';
1654: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1655:
1656: begin