APPS.BEN_DETERMINE_DATE dependencies on BEN_PGM_F

Line 163: from ben_pgm_f pgm

159:
160: cursor c_pgm_name
161: is
162: select name
163: from ben_pgm_f pgm
164: where pgm_id=p_pgm_id
165: and p_effective_Date between effective_start_date and effective_end_date;
166:
167: cursor c_pl_name

Line 205: l_pgm_name ben_pgm_f.name%type;

201:
202:
203: l_formula_type_id ff_formulas_f.formula_type_id%type;
204: l_formula_type_name ff_formula_types.formula_type_name%type;
205: l_pgm_name ben_pgm_f.name%type;
206: l_pl_name ben_pl_f.name%type;
207: l_opt_name ben_opt_f.name%type;
208: l_dummy number;
209: l_national_identifier per_all_people_f.national_identifier%type;

Line 6944: l_pgm_name ben_pgm_f.name%type;

6940: --
6941: -- Bug No 3965571
6942: --
6943: l_pln_name ben_pl_f.name%type;
6944: l_pgm_name ben_pgm_f.name%type;
6945: l_opt_name ben_opt_f.name%type;
6946: --
6947: -- Cursor declaration.
6948: --

Line 7079: from ben_pgm_f pgm

7075: pgm.rt_strt_dt_cd,
7076: pgm.rt_strt_dt_rl,
7077: pgm.rt_end_dt_cd,
7078: pgm.rt_end_dt_rl
7079: from ben_pgm_f pgm
7080: where pgm.pgm_id = c_pgm_id
7081: and c_effective_date
7082: between pgm.effective_start_date and pgm.effective_end_date
7083: order by 1; -- bug 5717428

Line 7274: from ben_pgm_f pgm

7270: pgm.rt_strt_dt_cd,
7271: pgm.rt_strt_dt_rl,
7272: pgm.rt_end_dt_cd,
7273: pgm.rt_end_dt_rl
7274: from ben_pgm_f pgm
7275: where pgm.pgm_id=c_pgm_id
7276: and c_effective_date
7277: between pgm.effective_start_date and pgm.effective_end_date
7278: and ( enrt_cvg_strt_dt_cd is not null

Line 7471: from ben_pgm_f pgm

7467: (c_pgm_id in number
7468: ,c_effective_date in date)
7469: is
7470: select pgm.name
7471: from ben_pgm_f pgm
7472: where pgm.pgm_id = c_pgm_id and pgm.business_group_id = p_business_group_id
7473: and c_effective_date between pgm.effective_start_date and pgm.effective_end_date;
7474:
7475: cursor c_opt