APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PL_F

Line 2401: l_pl_rec ben_pl_f%rowtype;

2397: l_person_freq_cd ben_schedd_hrs_rt_f.freq_cd%type;
2398: l_person_hours number;
2399: l_det_dt date;
2400: l_output ff_exec.outputs_t;
2401: l_pl_rec ben_pl_f%rowtype;
2402: l_pgm_rec ben_pgm_f%rowtype;
2403: l_package varchar2(80) := g_package||'.check_sched_hrs';
2404: --
2405: cursor c_scheduled_hours

Line 5052: from ben_pl_f pln,

5048: )
5049: is
5050: select /*+ bendtlep.check_othr_ptip.pilc1 */
5051: null
5052: from ben_pl_f pln,
5053: ben_plip_f cpp,
5054: ben_ptip_f ctp,
5055: ben_elig_per_f epo
5056: where pln.pl_id = cpp.pl_id

Line 5098: from ben_pl_f pln,

5094: )
5095: is
5096: select /*+ bendtlep.check_othr_ptip.c1 */
5097: null
5098: from ben_pl_f pln,
5099: ben_plip_f cpp,
5100: ben_ptip_f ctp,
5101: ben_pl_regn_f prg,
5102: ben_regn_f reg,

Line 5533: from ben_pl_f pln,

5529: l_pl_rec ben_comp_object.g_cache_pl_rec_table;
5530: --
5531: cursor c1(p_pl_id in number) is
5532: select null
5533: from ben_pl_f pln,
5534: ben_pl_regn_f prg,
5535: ben_regn_f reg
5536: where pln.pl_id = p_pl_id
5537: and pln.business_group_id = p_business_group_id

Line 5960: from ben_pl_f pln,

5956: ,c_dpnt_person_id in number
5957: )
5958: is
5959: select null
5960: from ben_pl_f pln,
5961: ben_plip_f cpp,
5962: ben_ptip_f ctp,
5963: ben_elig_per_f epo,
5964: ben_elig_dpnt edp,