APPS.PQH_RANKING dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 270: ben_elig_per_elctbl_chc epec

266: c_dt_start in date, c_dt_end in date) Is
267: SELECT rnk.rank_process_id,rnk.total_score
268: FROM pqh_rank_processes rnk,
269: ben_per_in_ler pil,
270: ben_elig_per_elctbl_chc epec
271: WHERE rnk.pgm_id = c_pgm_id
272: AND rnk.per_in_ler_id = pil.per_in_ler_id
273: AND per_in_ler_stat_cd = 'STRTD'
274: AND pil.business_group_id = p_business_group_id

Line 305: ben_elig_per_elctbl_chc epec

301: c_dt_start in date, c_dt_end in date ) Is
302: SELECT rnk.rank_process_id,rnk.total_score
303: FROM pqh_rank_processes rnk,
304: ben_per_in_ler pil,
305: ben_elig_per_elctbl_chc epec
306: WHERE rnk.pgm_id = c_pgm_id
307: AND rnk.pl_id = c_pl_id
308: AND rnk.per_in_ler_id = pil.per_in_ler_id
309: AND per_in_ler_stat_cd = 'STRTD'

Line 727: from ben_elig_per_elctbl_chc ec,

723: FROM (
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'

Line 766: from ben_elig_per_elctbl_chc ec,

762: pil.lf_evt_ocrd_dt, crit_tab_short_name,
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'

Line 806: from ben_elig_per_elctbl_chc ec,

802: lf_evt_ocrd_dt, person_id, per_in_ler_id, total_score,1
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'

Line 847: from ben_elig_per_elctbl_chc ec,

843: pil.lf_evt_ocrd_dt, crit_tab_short_name,
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'

Line 984: FROM ben_elig_per_elctbl_chc

980: --
981: Declare
982: CURSOR csr_pgm IS
983: SELECT pgm_id
984: FROM ben_elig_per_elctbl_chc
985: WHERE per_in_ler_id = p_per_in_ler_id
986: AND dflt_flag = 'Y'
987: AND rownum < 2;
988: --