DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PTIP_F

Line 8893: l_ptip2_rec ben_ptip_f%rowtype;

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

Line 8896: l_ptip_rec ben_ptip_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;
8897: --
8898: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;
8899: l_elig_rl_cnt number := 0;
8900: l_ctr_count number := 0;

Line 9052: from ben_ptip_f

9048: and tab3.effective_end_date;
9049:
9050: cursor c_ptip_pl_typ(c_effective_date date) is
9051: select pl_typ_id
9052: from ben_ptip_f
9053: where ptip_id = p_ptip_id
9054: and c_effective_date
9055: between effective_start_date
9056: and effective_end_date;