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 5109: from ben_pl_f pln,

5105: )
5106: is
5107: select /*+ bendtlep.check_othr_ptip.pilc1 */
5108: null
5109: from ben_pl_f pln,
5110: ben_plip_f cpp,
5111: ben_ptip_f ctp,
5112: ben_elig_per_f epo
5113: where pln.pl_id = cpp.pl_id

Line 5155: from ben_pl_f pln,

5151: )
5152: is
5153: select /*+ bendtlep.check_othr_ptip.c1 */
5154: null
5155: from ben_pl_f pln,
5156: ben_plip_f cpp,
5157: ben_ptip_f ctp,
5158: ben_pl_regn_f prg,
5159: ben_regn_f reg,

Line 5590: from ben_pl_f pln,

5586: l_pl_rec ben_comp_object.g_cache_pl_rec_table;
5587: --
5588: cursor c1(p_pl_id in number) is
5589: select null
5590: from ben_pl_f pln,
5591: ben_pl_regn_f prg,
5592: ben_regn_f reg
5593: where pln.pl_id = p_pl_id
5594: and pln.business_group_id = p_business_group_id

Line 6017: from ben_pl_f pln,

6013: ,c_dpnt_person_id in number
6014: )
6015: is
6016: select null
6017: from ben_pl_f pln,
6018: ben_plip_f cpp,
6019: ben_ptip_f ctp,
6020: ben_elig_per_f epo,
6021: ben_elig_dpnt edp,