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_CWB_SINGLE_PER_PROCESS_PKG dependencies on BEN_PER_IN_LER

Line 467: from ben_per_in_ler pil

463: select pil.per_in_ler_id
464: ,pil.per_in_ler_stat_cd
465: ,per.post_process_stat_cd
466: ,rates.group_per_in_ler_id rates_id
467: from ben_per_in_ler pil
468: ,ben_cwb_person_info per
469: ,ben_cwb_person_rates rates
470: where pil.person_id = p_person_id
471: and pil.group_pl_id = p_group_pl_id

Line 919: from ben_per_in_ler pil

915: ,l_elig_status
916: ,l_event_status
917: ,l_pp_stat_cd
918: ,l_pl_id
919: from ben_per_in_ler pil
920: ,ben_cwb_pl_dsgn grppln
921: ,ben_cwb_pl_dsgn pln
922: ,ben_cwb_person_rates rates
923: ,ben_cwb_person_info per

Line 931: and event_stat.lookup_type (+) = 'BEN_PER_IN_LER_STAT'

927: and pil.group_pl_id = p_group_pl_id
928: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
929: and pil.per_in_ler_stat_cd ='STRTD'
930: and pil.per_in_ler_id = per.group_per_in_ler_id
931: and event_stat.lookup_type (+) = 'BEN_PER_IN_LER_STAT'
932: and event_stat.lookup_code (+) = pil.per_in_ler_stat_cd
933: and event_stat.enabled_flag (+) = 'Y'
934: and pil.group_pl_id = grppln.pl_id
935: and grppln.oipl_id = -1