DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PTIP_F

Line 744: from ben_ptip_f

740: l_effective_date date ;
741: l_jurisdiction_code VARCHAR2(30);
742: cursor c_ptip(p_effective_date date) is
743: select pl_typ_id
744: from ben_ptip_f
745: where ptip_id=p_ptip_id and
746: business_group_id=p_business_group_id and
747: p_effective_date between
748: effective_start_date and effective_end_date;

Line 5516: from ben_ptip_f ptip

5512: l_package VARCHAR2(80)
5513: := g_package || '.get_comp_objects';
5514: cursor c_ptip is
5515: select pgm_id
5516: from ben_ptip_f ptip
5517: where ptip.ptip_id = p_ptip_id
5518: and nvl(g_fonm_cvg_strt_dt,p_effective_date)
5519: between ptip.effective_start_date and ptip.effective_end_date ;
5520: --

Line 10758: l_ptip_rec ben_ptip_f%ROWTYPE;

10754: --
10755: l_package VARCHAR2(80) := g_package || '.derive_rate_and_factors';
10756: --
10757: l_pgm_rec ben_pgm_f%ROWTYPE;
10758: l_ptip_rec ben_ptip_f%ROWTYPE;
10759: l_comp_rec g_cache_structure;
10760: l_oiplip_rec g_cache_structure;
10761: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10762: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;