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.GHR_CORR_CANC_SF52 dependencies on BEN_LER_F

Line 6257: ben_ler_f lf,

6253: p_effective_date in date)
6254: is
6255: select per_in_ler_id, ptnl_ler_for_per_stat_cd
6256: from ben_per_in_ler pil,
6257: ben_ler_f lf,
6258: ben_ptnl_ler_for_per ptnl
6259: where pil.person_id = p_person_id
6260: and pil.business_group_id = p_business_group_id
6261: and pil.lf_evt_ocrd_dt = p_effective_date

Line 6274: from ben_per_in_ler pil,ben_ler_f lf

6270: p_business_group_id in number,
6271: p_effective_date in date)
6272: is
6273: select per_in_ler_id,PER_IN_LER_STAT_CD
6274: from ben_per_in_ler pil,ben_ler_f lf
6275: where pil.person_id = p_person_id
6276: and pil.business_group_id = p_business_group_id
6277: and pil.lf_evt_ocrd_dt = p_effective_date
6278: and PER_IN_LER_STAT_CD IN ('PROCD','STRTD')