APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_ENRT_RT

Line 2420: From ben_enrt_rt ecr,

2416: decode(ecr.entr_val_at_enrt_flag, 'Y', ecr.dflt_val, ecr.val) val,
2417: ecr.cmcd_val,
2418: ecr.cmcd_acty_ref_perd_cd,
2419: ecr.nnmntry_uom
2420: From ben_enrt_rt ecr,
2421: ben_acty_base_rt_f abr
2422: Where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2423: AND ecr.dsply_on_enrt_flag = 'Y'
2424: AND ecr.enrt_bnft_id IS NULL

Line 2436: From ben_enrt_rt ecr,

2432: decode(ecr.entr_val_at_enrt_flag, 'Y', ecr.dflt_val, ecr.val) val,
2433: ecr.cmcd_val,
2434: ecr.cmcd_acty_ref_perd_cd,
2435: ecr.nnmntry_uom
2436: From ben_enrt_rt ecr,
2437: ben_enrt_bnft enb,
2438: ben_acty_base_rt_f abr
2439: Where enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2440: AND ecr.dsply_on_enrt_flag = 'Y'

Line 3076: From ben_enrt_rt ecr,

3072: decode(ecr.entr_val_at_enrt_flag, 'Y', ecr.dflt_val, ecr.val) val,
3073: ecr.cmcd_val,
3074: ecr.cmcd_acty_ref_perd_cd,
3075: ecr.nnmntry_uom
3076: From ben_enrt_rt ecr,
3077: ben_acty_base_rt_f abr
3078: Where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3079: AND ecr.dsply_on_enrt_flag = 'Y'
3080: AND ecr.enrt_bnft_id IS NULL

Line 3092: From ben_enrt_rt ecr,

3088: decode(ecr.entr_val_at_enrt_flag, 'Y', ecr.dflt_val, ecr.val) val,
3089: ecr.cmcd_val,
3090: ecr.cmcd_acty_ref_perd_cd,
3091: ecr.nnmntry_uom
3092: From ben_enrt_rt ecr,
3093: ben_enrt_bnft enb,
3094: ben_acty_base_rt_f abr
3095: Where enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3096: AND ecr.dsply_on_enrt_flag = 'Y'