APPS.BEN_DM_DOWNLOAD_DK dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 1998: -- DK Resolve from Table FND_ID_FLEX_STRUCTURES_VL

1994: --
1995: end if;
1996: end;
1997: --
1998: -- DK Resolve from Table FND_ID_FLEX_STRUCTURES_VL
1999: --
2000: procedure get_dk_frm_fit (p_business_group_name in VARCHAR2
2001: ,p_source_id in NUMBER
2002: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2004: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM

2000: procedure get_dk_frm_fit (p_business_group_name in VARCHAR2
2001: ,p_source_id in NUMBER
2002: ,p_resolve_mapping_id out nocopy NUMBER) is
2003: --
2004: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM
2005: --
2006: cursor csr_get_dk_fit is
2007: select id_flex_structure_name
2008: from fnd_id_flex_structures_vl

Line 2008: from fnd_id_flex_structures_vl

2004: -- cursor to Fetch the DK for FND_ID_FLEX_STRUCTURES_VL.ID_FLEX_NUM
2005: --
2006: cursor csr_get_dk_fit is
2007: select id_flex_structure_name
2008: from fnd_id_flex_structures_vl
2009: where id_flex_num = p_source_id;
2010:
2011: -- Declare local variables
2012: l_proc varchar2(72) := g_package || 'get_dk_frm_fit';

Line 2015: l_table_name varchar2(30) := 'FND_ID_FLEX_STRUCTURES_VL';

2011: -- Declare local variables
2012: l_proc varchar2(72) := g_package || 'get_dk_frm_fit';
2013: l_row_fetched boolean := FALSE;
2014: l_table_rec csr_get_dk_fit%rowtype;
2015: l_table_name varchar2(30) := 'FND_ID_FLEX_STRUCTURES_VL';
2016: l_column_name varchar2(30) := 'ID_FLEX_NUM';
2017: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2018:
2019: begin