DBA Data[Home] [Help]

APPS.HR_AUTH_BRIDGE dependencies on BEN_PRTT_RT_VAL

Line 18: FROM ben_prtt_rt_val prv

14: CURSOR c_ee_contrib IS
15: SELECT prv.cmcd_rt_val ||' '||
16: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
17: prv.cmcd_ref_perd_cd)
18: FROM ben_prtt_rt_val prv
19: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
20: AND prv.per_in_ler_id = p_per_in_ler_id
21: AND prv.acty_typ_cd = p_acty_typ_cd
22: AND prv.prtt_rt_val_stat_cd IS NULL

Line 29: FROM ben_prtt_rt_val prv

25: CURSOR c_er_contrib IS
26: SELECT prv.cmcd_rt_val ||' '||
27: HR_GENERAL.DECODE_LOOKUP('BEN_ENRT_INFO_RT_FREQ',
28: prv.cmcd_ref_perd_cd)
29: FROM ben_prtt_rt_val prv
30: WHERE prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
31: AND prv.per_in_ler_id = p_per_in_ler_id
32: AND prv.acty_typ_cd = p_acty_typ_cd
33: AND prv.prtt_rt_val_stat_cd IS NULL;