APPS.BENUTILS dependencies on BEN_PRTT_RT_VAL

Line 4670: from ben_prtt_rt_val prv

4666: return number is
4667: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4668: cursor c_prv1 is
4669: select nvl(prv.cmcd_rt_val,0)
4670: from ben_prtt_rt_val prv
4671: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4672: and prv.per_in_ler_id = p_per_in_ler_id
4673: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4674: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4683: from ben_prtt_rt_val prv

4679:
4680: /* Commented for Bug 6048854
4681: cursor c_prv2 is
4682: select nvl(prv.cmcd_rt_val,0)
4683: from ben_prtt_rt_val prv
4684: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4685: and prv.per_in_ler_id = p_per_in_ler_id
4686: Bug 5376185 : Pick the latest non-recurring rate
4687: and prv.rt_strt_dt = prv.rt_end_dt

Line 4727: from ben_prtt_rt_val prv

4723: return number is
4724: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4725: cursor c_prv1 is
4726: select nvl(prv.ann_rt_val,0)
4727: from ben_prtt_rt_val prv
4728: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4729: and prv.per_in_ler_id = p_per_in_ler_id
4730: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4731: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4739: from ben_prtt_rt_val prv

4735: --
4736: /* Commented for Bug 6048854
4737: cursor c_prv2 is
4738: select nvl(prv.ann_rt_val,0)
4739: from ben_prtt_rt_val prv
4740: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4741: and prv.per_in_ler_id = p_per_in_ler_id
4742: Bug 5376185 : Pick the latest non-recurring rate
4743: and prv.rt_strt_dt = prv.rt_end_dt

Line 4780: from ben_prtt_rt_val prv

4776: return varchar2 is
4777: --
4778: cursor c_prv is
4779: select to_char(nvl(prv.ann_rt_val,0))||'^'|| to_char(nvl(prv.cmcd_rt_val,0))||'^'||to_char(nvl(prv.rt_val,0))
4780: from ben_prtt_rt_val prv
4781: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4782: and prv.per_in_ler_id = p_per_in_ler_id
4783: and prv.rt_end_dt = hr_api.g_eot;
4784: --

Line 4810: from ben_prtt_rt_val prv

4806: return number is
4807: -- 4710155 : Old cursor prior to non-recurring rate fix 4460101
4808: cursor c_prv1 is
4809: select nvl(prv.rt_val,0)
4810: from ben_prtt_rt_val prv
4811: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4812: and prv.per_in_ler_id = p_per_in_ler_id
4813: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4814: and prv.rt_strt_dt <= prv.rt_end_dt;

Line 4822: from ben_prtt_rt_val prv

4818: --
4819: /*Commented for Bug 6048854
4820: cursor c_prv2 is
4821: select nvl(prv.rt_val,0)
4822: from ben_prtt_rt_val prv
4823: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4824: and prv.per_in_ler_id = p_per_in_ler_id
4825: Bug 5376185 : Pick the latest non-recurring rate
4826: and prv.rt_strt_dt = prv.rt_end_dt

Line 4931: from ben_prtt_rt_val prv,

4927: select enrt_rt_id,
4928: nvl(prv.rt_val, 0) val,
4929: nvl(prv.cmcd_rt_val, 0) rt_val,
4930: nvl(prv.ann_rt_val, 0) ann_rt_val
4931: from ben_prtt_rt_val prv,
4932: ben_enrt_rt ecr
4933: where prv.prtt_rt_val_id = ecr.prtt_rt_val_id
4934: and ecr.enrt_rt_id in (p_enrt_rt_id, p_enrt_rt_id2,
4935: p_enrt_rt_id3, p_enrt_rt_id4);