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_PER_IN_LER

Line 5903: from ben_per_in_ler pil,

5899: p_business_group_id in number,
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

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')

Line 5969: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,

5965: and c_effective_date between effective_start_date and effective_end_date;
5966:
5967: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
5968: p_pgm_id ben_pgm_f.pgm_id%type,
5969: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
5970: p_effective_date date)
5971: is
5972: select prtt_enrt_rslt_id,
5973: object_version_number,