APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_ACTN_TYP

Line 135: -- DK Resolve from Table BEN_ACTN_TYP

131: --
132: end if;
133: end;
134: --
135: -- DK Resolve from Table BEN_ACTN_TYP
136: --
137: procedure get_dk_frm_eat (p_business_group_name in VARCHAR2
138: ,p_source_id in NUMBER
139: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 141: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID

137: procedure get_dk_frm_eat (p_business_group_name in VARCHAR2
138: ,p_source_id in NUMBER
139: ,p_resolve_mapping_id out nocopy NUMBER) is
140: --
141: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID
142: --
143: cursor csr_get_dk_eat is
144: select name
145: from ben_actn_typ

Line 145: from ben_actn_typ

141: -- cursor to Fetch the DK for BEN_ACTN_TYP.ACTN_TYP_ID
142: --
143: cursor csr_get_dk_eat is
144: select name
145: from ben_actn_typ
146: where actn_typ_id = p_source_id;
147:
148: -- Declare local variables
149: l_proc varchar2(72) := g_package || 'get_dk_frm_eat';

Line 152: l_table_name varchar2(30) := 'BEN_ACTN_TYP';

148: -- Declare local variables
149: l_proc varchar2(72) := g_package || 'get_dk_frm_eat';
150: l_row_fetched boolean := FALSE;
151: l_table_rec csr_get_dk_eat%rowtype;
152: l_table_name varchar2(30) := 'BEN_ACTN_TYP';
153: l_column_name varchar2(30) := 'ACTN_TYP_ID';
154: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
155:
156: begin