APPS.BEN_PLI_BUS dependencies on BEN_PL_EXTRA_INFO

Line 28: -- ben_pl_extra_info and ben_BUSINESS_GROUPS

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

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_pl_extra_info pli
36: , ben_pl_f pl
37: where pli.pl_extra_info_id = p_pl_extra_info_id
38: and pl.pl_id = pli.pl_id
39: and pbg.business_group_id = pl.business_group_id;

Line 211: p_pl_id in ben_pl_extra_info.pl_id%type

207: -- ----------------------------------------------------------------------------
208:
209: Procedure chk_pl_id
210: (
211: p_pl_id in ben_pl_extra_info.pl_id%type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'chk_pl_id';
215: l_dummy varchar2(1);

Line 286: (p_information_type in ben_pl_extra_info.information_type%type

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

Line 287: ,p_pl_id in ben_pl_extra_info.pl_id%type

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

Line 302: from ben_pl_extra_info

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