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.BEN_PER_ASG_EIT_LER dependencies on BEN_PTNL_LER_FOR_PER

Line 118: from ben_ptnl_ler_for_per

114: cursor le_exists(p_person_id in number
115: ,p_ler_id in number
116: ,p_lf_evt_ocrd_dt in date) is
117: select 'Y'
118: from ben_ptnl_ler_for_per
119: where person_id = p_person_id
120: and ler_id = p_ler_id
121: and ptnl_ler_for_per_stat_cd = 'DTCTD'
122: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 497: from ben_ptnl_ler_for_per

493: cursor le_exists(p_person_id in number
494: ,p_ler_id in number
495: ,p_lf_evt_ocrd_dt in date) is
496: select 'Y'
497: from ben_ptnl_ler_for_per
498: where person_id = p_person_id
499: and ler_id = p_ler_id
500: and ptnl_ler_for_per_stat_cd = 'DTCTD'
501: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;