APPS.BEN_ABI_BUS dependencies on BEN_ABR_EXTRA_INFO

Line 28: -- ben_abr_extra_info and ben_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- In the following cursor statement add join(s) between
28: -- ben_abr_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_abr_extra_info abi

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_abr_extra_info abi
36: , ben_acty_base_rt_f abr
37: where abi.abr_extra_info_id = p_abr_extra_info_id
38: and abr.acty_base_rt_id = abi.acty_base_rt_id
39: and pbg.business_group_id = abr.business_group_id;

Line 211: p_acty_base_rt_id in ben_abr_extra_info.acty_base_rt_id%type

207: -- ----------------------------------------------------------------------------
208:
209: Procedure chk_acty_base_rt_id
210: (
211: p_acty_base_rt_id in ben_abr_extra_info.acty_base_rt_id%type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'chk_acty_base_rt_id';
215: l_dummy varchar2(1);

Line 286: (p_information_type in ben_abr_extra_info.information_type%type

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

Line 287: ,p_acty_base_rt_id in ben_abr_extra_info.acty_base_rt_id%type

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

Line 302: from ben_abr_extra_info

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