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.PQH_RANKING dependencies on BEN_CWB_PERSON_RATES

Line 931: From ben_cwb_person_rates pr,

927: lf_evt_ocrd_dt, total_score
928: FROM (
929: Select pr.group_pl_id, pr.person_id, pr.assignment_id,
930: pr.lf_evt_ocrd_dt, sum(sr.score) total_score
931: From ben_cwb_person_rates pr,
932: ben_benefit_actions ba,
933: ben_elig_per_opt_f epo,
934: ben_elig_per_f ep,
935: ben_elig_scre_wtg_f sr

Line 1073: ben_cwb_person_rates pr

1069: FROM (
1070: select rp.rank_process_id, rec_rnk.supervisor_id, rownum system_rank
1071: from pqh_rank_processes rp,
1072: ben_cwb_group_hrchy gh,
1073: ben_cwb_person_rates pr
1074: where gh.mgr_per_in_ler_id = rec_rnk.mgr_per_in_ler_id
1075: and gh.lvl_num > 0 -- don't include self
1076: and pr.group_per_in_ler_id = gh.emp_per_in_ler_id
1077: and rp.benefit_action_id = p_benefit_action_id