eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PL_F

Line 4121: l_pl_rec ben_pl_f%rowtype;

4117: l_output ff_exec.outputs_t;
4118: l_pgm_use_all_asnts_elig_flag varchar2(30);
4119: l_pl_use_all_asnts_elig_flag varchar2(30);
4120: l_use_all_asnts_elig_flag varchar2(30);
4121: l_pl_rec ben_pl_f%rowtype;
4122: l_pgm_rec ben_pgm_f%rowtype;
4123: --
4124: l_min_hours number;
4125: l_max_hours number;

Line 6875: from ben_pl_f pln,

6871: l_pl_rec ben_comp_object.g_cache_pl_rec_table;
6872: --
6873: cursor c1(p_pl_id in number,p_date_to_use date ) is
6874: select null
6875: from ben_pl_f pln,
6876: ben_pl_regn_f prg,
6877: ben_regn_f reg
6878: where pln.pl_id = p_pl_id
6879: and pln.business_group_id = p_business_group_id

Line 8883: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;

8879: l_dpnt_elig_flag varchar2(1) := 'Y';
8880: l_dependent_elig_flag varchar2(1) := 'Y';
8881: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8882: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8883: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8884: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8885: l_dpnt_pl_id ben_pl_f.pl_id%type;
8886: l_exists varchar2(30);
8887: --

Line 8885: l_dpnt_pl_id ben_pl_f.pl_id%type;

8881: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8882: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8883: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8884: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8885: l_dpnt_pl_id ben_pl_f.pl_id%type;
8886: l_exists varchar2(30);
8887: --
8888: l_terminated per_assignment_status_types.per_system_status%type ;
8889: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 8891: l_pl_rec ben_pl_f%rowtype;

8887: --
8888: l_terminated per_assignment_status_types.per_system_status%type ;
8889: l_assignment_id per_all_assignments_f.assignment_id%type;
8890: l_found_profile varchar2(1) := 'N';
8891: l_pl_rec ben_pl_f%rowtype;
8892: l_pl3_rec ben_pl_f%rowtype;
8893: l_ptip2_rec ben_ptip_f%rowtype;
8894: l_oipl_rec ben_oipl_f%rowtype;
8895: l_plip_rec ben_plip_f%rowtype;

Line 8892: l_pl3_rec ben_pl_f%rowtype;

8888: l_terminated per_assignment_status_types.per_system_status%type ;
8889: l_assignment_id per_all_assignments_f.assignment_id%type;
8890: l_found_profile varchar2(1) := 'N';
8891: l_pl_rec ben_pl_f%rowtype;
8892: l_pl3_rec ben_pl_f%rowtype;
8893: l_ptip2_rec ben_ptip_f%rowtype;
8894: l_oipl_rec ben_oipl_f%rowtype;
8895: l_plip_rec ben_plip_f%rowtype;
8896: l_ptip_rec ben_ptip_f%rowtype;

Line 9061: ben_pl_f pln

9057: --
9058: cursor c_plip_pl_typ(c_effective_date date) is
9059: select pln.pl_typ_id
9060: from ben_plip_f plip,
9061: ben_pl_f pln
9062: where plip_id = p_plip_id
9063: and c_effective_date
9064: between plip.effective_start_date and plip.effective_end_date
9065: and pln.pl_id = plip.pl_id

Line 9072: ben_pl_f pln

9068: --
9069: cursor c_oipl_pl_typ(c_effective_date date) is
9070: select pln.pl_typ_id
9071: from ben_oipl_f oipl,
9072: ben_pl_f pln
9073: where oipl_id = p_oipl_id
9074: and c_effective_date
9075: between oipl.effective_start_date and oipl.effective_end_date
9076: and pln.pl_id = oipl.pl_id