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 4132: l_pl_rec ben_pl_f%rowtype;

4128: l_output ff_exec.outputs_t;
4129: l_pgm_use_all_asnts_elig_flag varchar2(30);
4130: l_pl_use_all_asnts_elig_flag varchar2(30);
4131: l_use_all_asnts_elig_flag varchar2(30);
4132: l_pl_rec ben_pl_f%rowtype;
4133: l_pgm_rec ben_pgm_f%rowtype;
4134: --
4135: l_min_hours number;
4136: l_max_hours number;

Line 6887: from ben_pl_f pln,

6883: l_pl_rec ben_comp_object.g_cache_pl_rec_table;
6884: --
6885: cursor c1(p_pl_id in number,p_date_to_use date ) is
6886: select null
6887: from ben_pl_f pln,
6888: ben_pl_regn_f prg,
6889: ben_regn_f reg
6890: where pln.pl_id = p_pl_id
6891: and pln.business_group_id = p_business_group_id

Line 8902: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;

8898: l_dpnt_elig_flag varchar2(1) := 'Y';
8899: l_dependent_elig_flag varchar2(1) := 'Y';
8900: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8901: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8902: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8903: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8904: l_dpnt_pl_id ben_pl_f.pl_id%type;
8905: l_exists varchar2(30);
8906: --

Line 8904: l_dpnt_pl_id ben_pl_f.pl_id%type;

8900: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
8901: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
8902: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
8903: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
8904: l_dpnt_pl_id ben_pl_f.pl_id%type;
8905: l_exists varchar2(30);
8906: --
8907: l_terminated per_assignment_status_types.per_system_status%type ;
8908: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 8910: l_pl_rec ben_pl_f%rowtype;

8906: --
8907: l_terminated per_assignment_status_types.per_system_status%type ;
8908: l_assignment_id per_all_assignments_f.assignment_id%type;
8909: l_found_profile varchar2(1) := 'N';
8910: l_pl_rec ben_pl_f%rowtype;
8911: l_pl3_rec ben_pl_f%rowtype;
8912: l_ptip2_rec ben_ptip_f%rowtype;
8913: l_oipl_rec ben_oipl_f%rowtype;
8914: l_plip_rec ben_plip_f%rowtype;

Line 8911: l_pl3_rec ben_pl_f%rowtype;

8907: l_terminated per_assignment_status_types.per_system_status%type ;
8908: l_assignment_id per_all_assignments_f.assignment_id%type;
8909: l_found_profile varchar2(1) := 'N';
8910: l_pl_rec ben_pl_f%rowtype;
8911: l_pl3_rec ben_pl_f%rowtype;
8912: l_ptip2_rec ben_ptip_f%rowtype;
8913: l_oipl_rec ben_oipl_f%rowtype;
8914: l_plip_rec ben_plip_f%rowtype;
8915: l_ptip_rec ben_ptip_f%rowtype;

Line 9080: ben_pl_f pln

9076: --
9077: cursor c_plip_pl_typ(c_effective_date date) is
9078: select pln.pl_typ_id
9079: from ben_plip_f plip,
9080: ben_pl_f pln
9081: where plip_id = p_plip_id
9082: and c_effective_date
9083: between plip.effective_start_date and plip.effective_end_date
9084: and pln.pl_id = plip.pl_id

Line 9091: ben_pl_f pln

9087: --
9088: cursor c_oipl_pl_typ(c_effective_date date) is
9089: select pln.pl_typ_id
9090: from ben_oipl_f oipl,
9091: ben_pl_f pln
9092: where oipl_id = p_oipl_id
9093: and c_effective_date
9094: between oipl.effective_start_date and oipl.effective_end_date
9095: and pln.pl_id = oipl.pl_id