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 5904: ben_ler_f lf,

5900: p_effective_date in date)
5901: is
5902: select per_in_ler_id, ptnl_ler_for_per_stat_cd
5903: from ben_per_in_ler pil,
5904: ben_ler_f lf,
5905: ben_ptnl_ler_for_per ptnl
5906: where pil.person_id = p_person_id
5907: and pil.business_group_id = p_business_group_id
5908: and pil.lf_evt_ocrd_dt = p_effective_date

Line 5921: from ben_per_in_ler pil,ben_ler_f lf

5917: p_business_group_id in number,
5918: p_effective_date in date)
5919: is
5920: select per_in_ler_id,PER_IN_LER_STAT_CD
5921: from ben_per_in_ler pil,ben_ler_f lf
5922: where pil.person_id = p_person_id
5923: and pil.business_group_id = p_business_group_id
5924: and pil.lf_evt_ocrd_dt = p_effective_date
5925: and PER_IN_LER_STAT_CD IN ('PROCD','STRTD')