DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 400: from ben_ler_chg_dpnt_cvg_f chg

396: chg.cvg_eff_strt_rl,
397: chg.cvg_eff_end_rl,
398: chg.ler_chg_dpnt_cvg_cd,
399: chg.ler_chg_dpnt_cvg_rl
400: from ben_ler_chg_dpnt_cvg_f chg
401: where chg.ler_id = l_per_in_ler.ler_id
402: and chg.business_group_id = p_business_group_id
403: and decode(p_level,
404: 'PL',p_pl_id,

Line 424: from ben_ler_chg_dpnt_cvg_f chg,

420: chg.cvg_eff_strt_rl,
421: chg.cvg_eff_end_rl,
422: chg.ler_chg_dpnt_cvg_cd,
423: chg.ler_chg_dpnt_cvg_rl
424: from ben_ler_chg_dpnt_cvg_f chg,
425: ben_ptip_f ptip
426: where chg.ler_id = l_per_in_ler.ler_id
427: and chg.business_group_id = p_business_group_id
428: and chg.Ptip_id = ptip.ptip_id (+)