DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_PTIP_F

Line 8912: l_ptip2_rec ben_ptip_f%rowtype;

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

Line 8915: l_ptip_rec ben_ptip_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;
8916: --
8917: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;
8918: l_elig_rl_cnt number := 0;
8919: l_ctr_count number := 0;

Line 9071: from ben_ptip_f

9067: and tab3.effective_end_date;
9068:
9069: cursor c_ptip_pl_typ(c_effective_date date) is
9070: select pl_typ_id
9071: from ben_ptip_f
9072: where ptip_id = p_ptip_id
9073: and c_effective_date
9074: between effective_start_date
9075: and effective_end_date;