APPS.PQH_RANKING dependencies on BEN_ELIG_PER_F

Line 729: ben_elig_per_f ep,

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'
733: and ec.pgm_id = p_pgm_id

Line 768: ben_elig_per_f ep,

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'
772: and ec.pgm_id = p_pgm_id

Line 808: ben_elig_per_f ep,

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'
812: and ec.pgm_id = p_pgm_id

Line 849: ben_elig_per_f ep,

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'
853: and ec.pgm_id = p_pgm_id

Line 934: ben_elig_per_f ep,

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
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