APPS.PQH_RANKING dependencies on BEN_ELIG_SCRE_WTG_F

Line 728: ben_elig_scre_wtg_f sr,

724: select ec.pl_id, ec.per_in_ler_id,
725: ep.person_id, pil.lf_evt_ocrd_dt,
726: sum(sr.computed_score) total_score
727: from ben_elig_per_elctbl_chc ec,
728: ben_elig_scre_wtg_f sr,
729: ben_elig_per_f ep,
730: ben_per_in_ler pil
731: where ec. elig_flag = 'Y'
732: and ec.dflt_flag = 'Y'

Line 767: ben_elig_scre_wtg_f sr,

763: decode(p_handle_duplicate,'MAX', MAX(sr.computed_score)
764: ,'MIN', MIN(sr.computed_score)
765: ,'AVG', AVG(sr.computed_score) ) GROUP_score
766: from ben_elig_per_elctbl_chc ec,
767: ben_elig_scre_wtg_f sr,
768: ben_elig_per_f ep,
769: ben_per_in_ler pil
770: where ec. elig_flag = 'Y'
771: and ec.dflt_flag = 'Y'

Line 807: ben_elig_scre_wtg_f sr,

803: FROM (
804: select ec.pgm_id, ec.per_in_ler_id, ep.person_id,
805: pil.lf_evt_ocrd_dt, sum(sr.computed_score) total_score
806: from ben_elig_per_elctbl_chc ec,
807: ben_elig_scre_wtg_f sr,
808: ben_elig_per_f ep,
809: ben_per_in_ler pil
810: where ec. elig_flag = 'Y'
811: and ec.dflt_flag = 'Y'

Line 848: ben_elig_scre_wtg_f sr,

844: decode(p_handle_duplicate,'MAX', MAX(sr.computed_score)
845: ,'MIN', MIN(sr.computed_score)
846: ,'AVG', AVG(sr.computed_score) ) GROUP_score
847: from ben_elig_per_elctbl_chc ec,
848: ben_elig_scre_wtg_f sr,
849: ben_elig_per_f ep,
850: ben_per_in_ler pil
851: where ec. elig_flag = 'Y'
852: and ec.dflt_flag = 'Y'

Line 935: ben_elig_scre_wtg_f sr

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
936: Where ba.benefit_action_id = p_benefit_action_id
937: And pr.group_pl_id = ba.pl_id
938: And pr.pl_id = pr.group_pl_id
939: --