APPS.BEN_DETERMINE_DATE dependencies on BEN_PL_F

Line 170: from ben_pl_f pln

166:
167: cursor c_pl_name
168: is
169: select name
170: from ben_pl_f pln
171: where pl_id=p_pl_id
172: and p_effective_Date between effective_start_date and effective_end_date;
173:
174: cursor c_opt_name

Line 206: l_pl_name ben_pl_f.name%type;

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;
210:

Line 682: from ben_pl_f pl

678: l_opt c_opt%rowtype;
679: --
680: cursor c_pl_typ(l_pl_id number) is
681: select pl.pl_typ_id
682: from ben_pl_f pl
683: where pl.pl_id = l_pl_id
684: and pl.business_group_id = p_business_group_id
685: and nvl(l_lf_evt_ocrd_dt,p_effective_date)
686: between pl.effective_start_date

Line 6764: l_pln_name ben_pl_f.name%type;

6760: l_fonm_cvg_strt_dt date;
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.

Line 6872: from ben_pl_f pln

6868: pln.rt_strt_dt_cd,
6869: pln.rt_strt_dt_rl,
6870: pln.rt_end_dt_cd,
6871: pln.rt_end_dt_rl
6872: from ben_pl_f pln
6873: where pln.pl_id=c_pl_id
6874: and c_effective_date
6875: between pln.effective_start_date and pln.effective_end_date
6876: union

Line 6931: from ben_pl_f

6927: rt_strt_dt_cd,
6928: rt_strt_dt_rl,
6929: rt_end_dt_cd,
6930: rt_end_dt_rl
6931: from ben_pl_f
6932: where pl_id=l_pl_id and
6933: business_group_id =p_business_group_id and
6934: nvl(p_lf_evt_ocrd_dt,p_effective_date) between
6935: effective_start_date and effective_end_date

Line 7057: from ben_pl_f pln

7053: pln.rt_strt_dt_cd,
7054: pln.rt_strt_dt_rl,
7055: pln.rt_end_dt_cd,
7056: pln.rt_end_dt_rl
7057: from ben_pl_f pln
7058: where pln.pl_id=c_pl_id
7059: and c_effective_date
7060: between pln.effective_start_date and pln.effective_end_date
7061: and ( enrt_cvg_strt_dt_cd is not null

Line 7133: from ben_pl_f

7129: rt_strt_dt_cd,
7130: rt_strt_dt_rl,
7131: rt_end_dt_cd,
7132: rt_end_dt_rl
7133: from ben_pl_f
7134: where pl_id=l_pl_id and
7135: business_group_id =p_business_group_id and
7136: nvl(p_lf_evt_ocrd_dt,p_effective_date) between
7137: effective_start_date and effective_end_date

Line 7176: ben_pl_f pln

7172: )
7173: is
7174: select ptp.ptip_id
7175: from ben_ptip_f ptp,
7176: ben_pl_f pln
7177: where ptp.pl_typ_id = pln.pl_typ_id
7178: and c_effective_date
7179: between pln.effective_start_date and pln.effective_end_date
7180: and ptp.pgm_id = c_pgm_id

Line 7283: from ben_pl_f pln

7279: (c_pl_id in number
7280: ,c_effective_date in date)
7281: is
7282: select pln.name
7283: from ben_pl_f pln
7284: where pln.pl_id = c_pl_id and pln.business_group_id = p_business_group_id
7285: and c_effective_date between pln.effective_start_date and pln.effective_end_date;
7286:
7287: cursor c_pgm