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_PER_IN_LER

Line 215: ben_per_in_ler pil

211: */
212: Cursor csr_pgm_no_ba (c_dt_start in date, c_dt_end date) is
213: select distinct rnk.pgm_id
214: FROM pqh_rank_processes rnk,
215: ben_per_in_ler pil
216: where (p_pl_id is null OR rnk.pl_id = p_pl_id)
217: and rnk.per_in_ler_id = pil.per_in_ler_id
218: and pil.business_group_id = p_business_group_id
219: and pil.per_in_ler_stat_cd = 'STRTD'

Line 241: ben_per_in_ler pil

237: cursor csr_gr_no_ba (c_pgm_id in number, c_pl_id in number,
238: c_dt_start in date, c_dt_end in date ) is
239: select rnk.pl_id, count(1) emp_cnt
240: FROM pqh_rank_processes rnk,
241: ben_per_in_ler pil
242: where rnk.pgm_id = c_pgm_id
243: and (c_pl_id is null OR rnk.pl_id = c_pl_id)
244: and rnk.per_in_ler_id = pil.per_in_ler_id
245: and pil.business_group_id = p_business_group_id

Line 269: ben_per_in_ler pil,

265: Cursor csr_rnk_pgm_no_ba (c_pgm_id in number,
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'

Line 304: ben_per_in_ler pil,

300: Cursor csr_rnk_pl_no_ba( c_pgm_id in number, c_pl_id in number ,
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

Line 730: ben_per_in_ler pil

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
734: and ec.per_in_ler_id = p_per_in_ler_id

Line 769: ben_per_in_ler pil

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
773: and ec.per_in_ler_id = p_per_in_ler_id

Line 809: ben_per_in_ler pil

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

Line 850: ben_per_in_ler pil

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
854: and ec.per_in_ler_id = p_per_in_ler_id