APPS.BEN_ELI_BUS dependencies on BEN_ELP_EXTRA_INFO

Line 28: -- ben_elp_extra_info and ben_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- In the following cursor statement add join(s) between
28: -- ben_elp_extra_info and ben_BUSINESS_GROUPS
29: -- so that the legislation_code for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is

Line 35: , ben_elp_extra_info eli

31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is
33: select pbg.legislation_code
34: from per_business_groups pbg
35: , ben_elp_extra_info eli
36: , ben_eligy_prfl_f elp
37: where eli.elp_extra_info_id = p_elp_extra_info_id
38: and elp.eligy_prfl_id = eli.eligy_prfl_id
39: and pbg.business_group_id = elp.business_group_id;

Line 211: p_eligy_prfl_id in ben_elp_extra_info.eligy_prfl_id%type

207: -- ----------------------------------------------------------------------------
208:
209: Procedure chk_eligy_prfl_id
210: (
211: p_eligy_prfl_id in ben_elp_extra_info.eligy_prfl_id%type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'chk_eligy_prfl_id';
215: l_dummy varchar2(1);

Line 286: (p_information_type in ben_elp_extra_info.information_type%type

282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure chk_multiple_occurences_flag
286: (p_information_type in ben_elp_extra_info.information_type%type
287: ,p_eligy_prfl_id in ben_elp_extra_info.eligy_prfl_id%type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';

Line 287: ,p_eligy_prfl_id in ben_elp_extra_info.eligy_prfl_id%type

283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure chk_multiple_occurences_flag
286: (p_information_type in ben_elp_extra_info.information_type%type
287: ,p_eligy_prfl_id in ben_elp_extra_info.eligy_prfl_id%type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
291: l_multi_occur_flag ben_elp_info_types.multiple_occurences_flag%type;

Line 302: from ben_elp_extra_info

298: where information_type = code;
299: --
300: cursor c_get_row (code varchar2, id number) is
301: select 'x'
302: from ben_elp_extra_info
303: where information_type = code
304: and eligy_prfl_id = id;
305: --
306: Begin