DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 465: from ben_apld_dpnt_cvg_elig_prfl_f ade,

461: dce.dpnt_mltry_flag,
462: dce.dpnt_pstl_flag,
463: dce.dpnt_cvrd_in_anthr_pl_flag,
464: dce.dpnt_dsgnt_crntly_enrld_flag
465: from ben_apld_dpnt_cvg_elig_prfl_f ade,
466: ben_dpnt_cvg_eligy_prfl_f dce
467: where decode(c_lvl,
468: 'PL',c_pl_id,
469: 'PTIP',c_ptip_id,

Line 501: from ben_apld_dpnt_cvg_elig_prfl_f ade

497: is
498: select ade.dpnt_cvg_eligy_prfl_id,
499: ade.mndtry_flag,
500: ade.apld_dpnt_cvg_elig_rl
501: from ben_apld_dpnt_cvg_elig_prfl_f ade
502: where decode(c_lvl,
503: 'PL',c_pl_id,
504: 'PTIP',c_ptip_id,
505: 'PGM', c_pgm_id) =