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 6765: l_pgm_name ben_pgm_f.name%type;

6761: --
6762: -- Bug No 3965571
6763: --
6764: l_pln_name ben_pl_f.name%type;
6765: l_pgm_name ben_pgm_f.name%type;
6766: l_opt_name ben_opt_f.name%type;
6767: --
6768: -- Cursor declaration.
6769: --

Line 6900: from ben_pgm_f pgm

6896: pgm.rt_strt_dt_cd,
6897: pgm.rt_strt_dt_rl,
6898: pgm.rt_end_dt_cd,
6899: pgm.rt_end_dt_rl
6900: from ben_pgm_f pgm
6901: where pgm.pgm_id = c_pgm_id
6902: and c_effective_date
6903: between pgm.effective_start_date and pgm.effective_end_date
6904: order by 1; -- bug 5717428

Line 7095: from ben_pgm_f pgm

7091: pgm.rt_strt_dt_cd,
7092: pgm.rt_strt_dt_rl,
7093: pgm.rt_end_dt_cd,
7094: pgm.rt_end_dt_rl
7095: from ben_pgm_f pgm
7096: where pgm.pgm_id=c_pgm_id
7097: and c_effective_date
7098: between pgm.effective_start_date and pgm.effective_end_date
7099: and ( enrt_cvg_strt_dt_cd is not null

Line 7292: from ben_pgm_f pgm

7288: (c_pgm_id in number
7289: ,c_effective_date in date)
7290: is
7291: select pgm.name
7292: from ben_pgm_f pgm
7293: where pgm.pgm_id = c_pgm_id and pgm.business_group_id = p_business_group_id
7294: and c_effective_date between pgm.effective_start_date and pgm.effective_end_date;
7295:
7296: cursor c_opt