eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_ENRT_BNFT

Line 2249: FROM ben_enrt_bnft

2245: ,p_business_group_id IN NUMBER)
2246: RETURN NUMBER IS
2247: CURSOR csr_get_cvg_amt IS
2248: SELECT val
2249: FROM ben_enrt_bnft
2250: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2251: AND business_group_id = p_business_group_id
2252: AND bnft_typ_cd = 'CVG' ;
2253:

Line 2254: l_coverage_amount ben_enrt_bnft.val%TYPE;

2250: WHERE elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2251: AND business_group_id = p_business_group_id
2252: AND bnft_typ_cd = 'CVG' ;
2253:
2254: l_coverage_amount ben_enrt_bnft.val%TYPE;
2255: l_proc VARCHAR2(72);
2256:
2257: BEGIN
2258: --

Line 2437: ben_enrt_bnft enb,

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

Line 3093: ben_enrt_bnft enb,

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