APPS.BEN_DM_DOWNLOAD_DK dependencies on FF_FORMULAS_F

Line 1933: -- DK Resolve from Table FF_FORMULAS_F

1929: ,p_business_group_name => p_business_group_name);
1930: end if;
1931: end;
1932: --
1933: -- DK Resolve from Table FF_FORMULAS_F
1934: --
1935: procedure get_dk_frm_fra (p_business_group_name in VARCHAR2
1936: ,p_source_id in NUMBER
1937: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 1939: -- cursor to Fetch the DK for FF_FORMULAS_F.FORMULA_ID

1935: procedure get_dk_frm_fra (p_business_group_name in VARCHAR2
1936: ,p_source_id in NUMBER
1937: ,p_resolve_mapping_id out nocopy NUMBER) is
1938: --
1939: -- cursor to Fetch the DK for FF_FORMULAS_F.FORMULA_ID
1940: --
1941: cursor csr_get_dk_fra is
1942: select formula_name
1943: from ff_formulas_f

Line 1943: from ff_formulas_f

1939: -- cursor to Fetch the DK for FF_FORMULAS_F.FORMULA_ID
1940: --
1941: cursor csr_get_dk_fra is
1942: select formula_name
1943: from ff_formulas_f
1944: where formula_id = p_source_id;
1945:
1946: -- Declare local variables
1947: l_proc varchar2(72) := g_package || 'get_dk_frm_fra';

Line 1950: l_table_name varchar2(30) := 'FF_FORMULAS_F';

1946: -- Declare local variables
1947: l_proc varchar2(72) := g_package || 'get_dk_frm_fra';
1948: l_row_fetched boolean := FALSE;
1949: l_table_rec csr_get_dk_fra%rowtype;
1950: l_table_name varchar2(30) := 'FF_FORMULAS_F';
1951: l_column_name varchar2(30) := 'FORMULA_ID';
1952: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1953:
1954: begin