DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on BEN_PTNL_LER_FOR_PER

Line 254: ,ben_ptnl_ler_for_per plr

250: SELECT MAX(pil.bckt_dt)
251: FROM ben_per_in_ler pil
252: -- CWB changes
253: ,ben_ler_f ler
254: ,ben_ptnl_ler_for_per plr
255: WHERE pil.person_id = c_per_id
256: AND pil.ler_id = ler.ler_id
257: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')
258: and c_effdt