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 6256: from ben_per_in_ler pil,

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

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

Line 6322: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,

6318: and c_effective_date between effective_start_date and effective_end_date;
6319:
6320: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
6321: p_pgm_id ben_pgm_f.pgm_id%type,
6322: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
6323: p_effective_date date)
6324: is
6325: select prtt_enrt_rslt_id,
6326: object_version_number,