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 HR_LOOKUPS

Line 791: from hr_lookups

787: end if;
788: --
789: -- set the p_method_display with lookup value
790: select meaning into p_method_display
791: from hr_lookups
792: where lookup_type = 'BEN_CWB_ADMIN_PP_TYPE'
793: and lookup_code = p_method;
794:
795: -- set the p_term_date with lookup value, if it is null

Line 798: from hr_lookups

794:
795: -- set the p_term_date with lookup value, if it is null
796: if p_term_date is null then
797: select meaning into p_term_date
798: from hr_lookups
799: where lookup_type = 'BEN_CWB_MISC_TEXT'
800: and lookup_code = 'ONGOING';
801: end if;
802: --

Line 924: ,hr_lookups elig_stat

920: ,ben_cwb_pl_dsgn grppln
921: ,ben_cwb_pl_dsgn pln
922: ,ben_cwb_person_rates rates
923: ,ben_cwb_person_info per
924: ,hr_lookups elig_stat
925: ,hr_lookups event_stat
926: where pil.person_id = p_person_id
927: and pil.group_pl_id = p_group_pl_id
928: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 925: ,hr_lookups event_stat

921: ,ben_cwb_pl_dsgn pln
922: ,ben_cwb_person_rates rates
923: ,ben_cwb_person_info per
924: ,hr_lookups elig_stat
925: ,hr_lookups event_stat
926: where pil.person_id = p_person_id
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'