DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_ACTY_BASE_RT_F

Line 2421: ben_acty_base_rt_f abr

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
2425: AND abr.acty_base_rt_id = ecr.acty_base_rt_id

Line 2438: ben_acty_base_rt_f abr

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'
2441: AND enb.enrt_bnft_id = ecr.enrt_bnft_id
2442: AND abr.acty_base_rt_id = ecr.acty_base_rt_id

Line 3077: ben_acty_base_rt_f abr

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
3081: AND abr.acty_base_rt_id = ecr.acty_base_rt_id

Line 3094: ben_acty_base_rt_f abr

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'
3097: AND enb.enrt_bnft_id = ecr.enrt_bnft_id
3098: AND abr.acty_base_rt_id = ecr.acty_base_rt_id