APPS.BEN_PGI_BUS dependencies on BEN_PGM_EXTRA_INFO

Line 28: -- ben_pgm_extra_info and ben_BUSINESS_GROUPS

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

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_pgm_extra_info pgi
36: , ben_pgm_f pgm
37: where pgi.pgm_extra_info_id = p_pgm_extra_info_id
38: and pgm.pgm_id = pgi.pgm_id
39: and pbg.business_group_id = pgm.business_group_id;

Line 211: p_pgm_id in ben_pgm_extra_info.pgm_id%type

207: -- ----------------------------------------------------------------------------
208:
209: Procedure chk_pgm_id
210: (
211: p_pgm_id in ben_pgm_extra_info.pgm_id%type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'chk_pgm_id';
215: l_dummy varchar2(1);

Line 286: (p_information_type in ben_pgm_extra_info.information_type%type

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

Line 287: ,p_pgm_id in ben_pgm_extra_info.pgm_id%type

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

Line 302: from ben_pgm_extra_info

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