DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 398: from ben_ler_chg_dpnt_cvg_f chg

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

Line 422: from ben_ler_chg_dpnt_cvg_f chg,

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