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_MASS_NOTIFN_PKG dependencies on BEN_CWB_PERSON_RATES

Line 112: AND EXISTS( select person_rates.elig_flag from ben_cwb_person_rates person_rates

108: AND hrchy.emp_per_in_ler_id = pil.per_in_ler_id
109: AND (((v_target_pop IS NOT NULL)
110: AND (
111: ((v_target_pop = 'ELI')
112: AND EXISTS( select person_rates.elig_flag from ben_cwb_person_rates person_rates
113: where person_rates.group_per_in_ler_id = pil.per_in_ler_id
114: and person_rates.group_pl_id = pil.group_pl_id
115: AND person_rates.elig_flag = 'Y')
116: AND (hrchy.lvl_num = (SELECT MAX (lvl_num)

Line 121: AND EXISTS( select * from ben_cwb_person_rates person_rates

117: FROM ben_cwb_group_hrchy hr
118: WHERE hr.emp_per_in_ler_id = hrchy.emp_per_in_ler_id)))
119: OR
120: ((v_target_pop = 'EPO')
121: AND EXISTS( select * from ben_cwb_person_rates person_rates
122: where person_rates.group_per_in_ler_id = pil.per_in_ler_id
123: and person_rates.group_pl_id = pil.group_pl_id
124: and ((person_rates.pay_proposal_id is not null)
125: or (person_rates.element_entry_value_id is not null)))

Line 187: from ben_cwb_person_rates rts

183: OR
184: ((v_target_pop = 'MEL')
185: AND (hrchy.lvl_num = 0)
186: AND EXISTS (select rts.elig_flag
187: from ben_cwb_person_rates rts
188: ,ben_cwb_group_hrchy hier
189: where hier.mgr_per_in_ler_id = hrchy.mgr_per_in_ler_id
190: and rts.group_per_in_ler_id = hier.emp_per_in_ler_id
191: and rts.elig_flag = 'Y'