APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_OPT_F

Line 1400: -- DK Resolve from Table BEN_OPT_F

1396: ,p_business_group_name => p_business_group_name);
1397: end if;
1398: end;
1399: --
1400: -- DK Resolve from Table BEN_OPT_F
1401: --
1402: procedure get_dk_frm_opt (p_business_group_name in VARCHAR2
1403: ,p_source_id in NUMBER
1404: ,p_resolve_mapping_id out nocopy NUMBER) is

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

1402: procedure get_dk_frm_opt (p_business_group_name in VARCHAR2
1403: ,p_source_id in NUMBER
1404: ,p_resolve_mapping_id out nocopy NUMBER) is
1405: --
1406: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID
1407: --
1408: cursor csr_get_dk_opt is
1409: select name
1410: from ben_opt_f

Line 1410: from ben_opt_f

1406: -- cursor to Fetch the DK for BEN_OPT_F.OPT_ID
1407: --
1408: cursor csr_get_dk_opt is
1409: select name
1410: from ben_opt_f
1411: where opt_id = p_source_id;
1412:
1413: -- Declare local variables
1414: l_proc varchar2(72) := g_package || 'get_dk_frm_opt';

Line 1417: l_table_name varchar2(30) := 'BEN_OPT_F';

1413: -- Declare local variables
1414: l_proc varchar2(72) := g_package || 'get_dk_frm_opt';
1415: l_row_fetched boolean := FALSE;
1416: l_table_rec csr_get_dk_opt%rowtype;
1417: l_table_name varchar2(30) := 'BEN_OPT_F';
1418: l_column_name varchar2(30) := 'OPT_ID';
1419: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1420:
1421: begin