APPS.BENUTILS dependencies on BEN_PRTT_RT_VAL

Line 4795: from ben_prtt_rt_val prv

4791: return number is
4792: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4793: cursor c_prv1 is
4794: select nvl(prv.cmcd_rt_val,0)
4795: from ben_prtt_rt_val prv
4796: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4797: and prv.per_in_ler_id = p_per_in_ler_id
4798: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4799: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4808: from ben_prtt_rt_val prv

4804:
4805: /* Commented for Bug 6048854
4806: cursor c_prv2 is
4807: select nvl(prv.cmcd_rt_val,0)
4808: from ben_prtt_rt_val prv
4809: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4810: and prv.per_in_ler_id = p_per_in_ler_id
4811: Bug 5376185 : Pick the latest non-recurring rate
4812: and prv.rt_strt_dt = prv.rt_end_dt

Line 4852: from ben_prtt_rt_val prv

4848: return number is
4849: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4850: cursor c_prv1 is
4851: select nvl(prv.ann_rt_val,0)
4852: from ben_prtt_rt_val prv
4853: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4854: and prv.per_in_ler_id = p_per_in_ler_id
4855: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4856: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4864: from ben_prtt_rt_val prv

4860: --
4861: /* Commented for Bug 6048854
4862: cursor c_prv2 is
4863: select nvl(prv.ann_rt_val,0)
4864: from ben_prtt_rt_val prv
4865: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4866: and prv.per_in_ler_id = p_per_in_ler_id
4867: Bug 5376185 : Pick the latest non-recurring rate
4868: and prv.rt_strt_dt = prv.rt_end_dt

Line 4905: from ben_prtt_rt_val prv

4901: return varchar2 is
4902: --
4903: cursor c_prv is
4904: select to_char(nvl(prv.ann_rt_val,0))||'^'|| to_char(nvl(prv.cmcd_rt_val,0))||'^'||to_char(nvl(prv.rt_val,0))
4905: from ben_prtt_rt_val prv
4906: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4907: and prv.per_in_ler_id = p_per_in_ler_id
4908: and prv.rt_end_dt = hr_api.g_eot;
4909: --

Line 4935: from ben_prtt_rt_val prv

4931: return number is
4932: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4933: cursor c_prv1 is
4934: select nvl(prv.rt_val,0)
4935: from ben_prtt_rt_val prv
4936: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4937: and prv.per_in_ler_id = p_per_in_ler_id
4938: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4939: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4947: from ben_prtt_rt_val prv

4943: --
4944: /*Commented for Bug 6048854
4945: cursor c_prv2 is
4946: select nvl(prv.rt_val,0)
4947: from ben_prtt_rt_val prv
4948: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4949: and prv.per_in_ler_id = p_per_in_ler_id
4950: Bug 5376185 : Pick the latest non-recurring rate
4951: and prv.rt_strt_dt = prv.rt_end_dt

Line 5056: from ben_prtt_rt_val prv,

5052: select enrt_rt_id,
5053: nvl(prv.rt_val, 0) val,
5054: nvl(prv.cmcd_rt_val, 0) rt_val,
5055: nvl(prv.ann_rt_val, 0) ann_rt_val
5056: from ben_prtt_rt_val prv,
5057: ben_enrt_rt ecr
5058: where prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5059: and ecr.enrt_rt_id in (p_enrt_rt_id, p_enrt_rt_id2,
5060: p_enrt_rt_id3, p_enrt_rt_id4);