DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PTIP_F

Line 745: from ben_ptip_f

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

Line 5517: from ben_ptip_f ptip

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

Line 10831: l_ptip_rec ben_ptip_f%ROWTYPE;

10827: --
10828: l_package VARCHAR2(80) := g_package || '.derive_rate_and_factors';
10829: --
10830: l_pgm_rec ben_pgm_f%ROWTYPE;
10831: l_ptip_rec ben_ptip_f%ROWTYPE;
10832: l_comp_rec g_cache_structure;
10833: l_oiplip_rec g_cache_structure;
10834: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10835: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;