APPS.BEN_OPR_BUS dependencies on BEN_OTHR_PTIP_RT_F

Line 129: from ben_othr_ptip_rt_f opr

125: between ctp.effective_start_date and ctp.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_othr_ptip_rt_f opr
130: where opr.ptip_id = p_ptip_id
131: and opr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and opr.othr_ptip_rt_id <> nvl(p_othr_ptip_rt_id,hr_api.g_number)
133:

Line 373: from ben_othr_ptip_rt_f

369: is
370: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
371: l_dummy char(1);
372: cursor c1 is select null
373: from ben_othr_ptip_rt_f
374: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
375: -- changed against bug: 5113011
376: and othr_ptip_rt_id <> nvl(p_othr_ptip_rt_id ,-1)
377: -- and ptip_id <> nvl(p_ptip_id ,-1)

Line 784: ben_othr_ptip_rt_f b

780: --
781: cursor csr_leg_code is
782: select a.legislation_code
783: from per_business_groups a,
784: ben_othr_ptip_rt_f b
785: where b.othr_ptip_rt_id = p_othr_ptip_rt_id
786: and a.business_group_id = b.business_group_id;
787: --
788: -- Declare local variables