APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_OIPL_F

Line 1304: -- DK Resolve from Table BEN_OIPL_F

1300: --
1301: end if;
1302: end;
1303: --
1304: -- DK Resolve from Table BEN_OIPL_F
1305: --
1306: procedure get_dk_frm_cop (p_business_group_name in VARCHAR2
1307: ,p_source_id in NUMBER
1308: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1310: -- cursor to Fetch the DK for BEN_OIPL_F.OIPL

1306: procedure get_dk_frm_cop (p_business_group_name in VARCHAR2
1307: ,p_source_id in NUMBER
1308: ,p_resolve_mapping_id out nocopy NUMBER) is
1309: --
1310: -- cursor to Fetch the DK for BEN_OIPL_F.OIPL
1311: --
1312: cursor csr_get_dk_cop is
1313: select *
1314: from ben_oipl_f

Line 1314: from ben_oipl_f

1310: -- cursor to Fetch the DK for BEN_OIPL_F.OIPL
1311: --
1312: cursor csr_get_dk_cop is
1313: select *
1314: from ben_oipl_f
1315: where oipl_id = p_source_id;
1316:
1317: -- Declare local variables
1318: l_proc varchar2(72) := g_package || 'get_dk_frm_cop';

Line 1321: l_table_name varchar2(30) := 'BEN_OIPL_F';

1317: -- Declare local variables
1318: l_proc varchar2(72) := g_package || 'get_dk_frm_cop';
1319: l_row_fetched boolean := FALSE;
1320: l_table_rec csr_get_dk_cop%rowtype;
1321: l_table_name varchar2(30) := 'BEN_OIPL_F';
1322: l_column_name varchar2(30) := 'OIPL_ID';
1323: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1324: l_opt_id number;
1325: l_pl_id number;