APPS.PQH_RANKING dependencies on BEN_CWB_GROUP_HRCHY

Line 1051: FROM ben_cwb_group_hrchy gh,

1047: p_benefit_action_id IN NUMBER) IS
1048: --
1049: CURSOR csr_rnk IS
1050: SELECT mgr_per_in_ler_id, pi.person_id supervisor_id
1051: FROM ben_cwb_group_hrchy gh,
1052: ben_cwb_person_info pi
1053: WHERE gh.lvl_num = 0
1054: AND gh.mgr_per_in_ler_id = pi.group_per_in_ler_id;
1055: --

Line 1072: ben_cwb_group_hrchy gh,

1068: system_rank
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