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 PQH_RANK_PROCESSES

Line 55: FROM pqh_rank_processes

51:
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: SELECT count(1)
54: INTO l_count
55: FROM pqh_rank_processes
56: WHERE pgm_id = p_pgm_id
57: AND (p_benefit_action_id IS NULL or benefit_action_id = p_benefit_action_id);
58:
59: RETURN l_count;

Line 205: FROM pqh_rank_processes

201: * benefit action
202: */
203: CURSOR csr_pgm IS
204: SELECT distinct pgm_id
205: FROM pqh_rank_processes
206: WHERE benefit_action_id = p_benefit_action_id;
207:
208: /*
209: * Cursor to find grade ladders within a given time

Line 214: FROM pqh_rank_processes rnk,

210: * period and/or the grade
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

Line 228: FROM pqh_rank_processes

224: * and benefit action
225: */
226: CURSOR csr_gr (c_pgm_id in number) IS
227: SELECT pl_id, count(1) emp_cnt
228: FROM pqh_rank_processes
229: WHERE (p_benefit_action_id is null or benefit_action_id = p_benefit_action_id)
230: AND pgm_id = c_pgm_id
231: GROUP BY pl_id;
232:

Line 240: FROM pqh_rank_processes rnk,

236: */
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

Line 256: FROM pqh_rank_processes

252: * and benefit action
253: */
254: Cursor csr_rnk_pgm (c_pgm_id in number) Is
255: SELECT rank_process_id, total_score
256: FROM pqh_rank_processes
257: WHERE benefit_action_id = p_benefit_action_id
258: AND pgm_id = c_pgm_id
259: ORDER BY total_score DESC;
260:

Line 268: FROM pqh_rank_processes rnk,

264: */
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

Line 290: FROM pqh_rank_processes

286: * grade ladder and benefit action
287: */
288: Cursor csr_rnk_pl( c_pgm_id in number, c_pl_id in number ) Is
289: SELECT rank_process_id, total_score
290: FROM pqh_rank_processes
291: WHERE benefit_action_id = p_benefit_action_id
292: AND pgm_id = c_pgm_id
293: AND pl_id = c_pl_id
294: ORDER BY total_score DESC;

Line 303: FROM pqh_rank_processes rnk,

299: */
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

Line 716: INSERT INTO pqh_rank_processes (

712: hr_utility.set_location('Grouping by Grade',5);
713: IF ( p_handle_duplicate = 'SUM') THEN
714: --
715: --
716: INSERT INTO pqh_rank_processes (
717: rank_process_id, process_cd, pgm_id, pl_id,
718: benefit_action_id, process_date, person_id,
719: per_in_ler_id, total_score, object_version_number)
720: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,

Line 720: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,

716: INSERT INTO pqh_rank_processes (
717: rank_process_id, process_cd, pgm_id, pl_id,
718: benefit_action_id, process_date, person_id,
719: per_in_ler_id, total_score, object_version_number)
720: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,
721: p_benefit_action_id, lf_evt_ocrd_dt,
722: person_id, per_in_ler_id, total_score, 1
723: FROM (
724: select ec.pl_id, ec.per_in_ler_id,

Line 751: INSERT INTO pqh_rank_processes (

747: );
748: --
749: ELSE
750: ---
751: INSERT INTO pqh_rank_processes (
752: rank_process_id, process_cd, pgm_id,pl_id,
753: benefit_action_id,process_date, person_id,
754: per_in_ler_id, total_score, object_version_number)
755: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,

Line 755: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,

751: INSERT INTO pqh_rank_processes (
752: rank_process_id, process_cd, pgm_id,pl_id,
753: benefit_action_id,process_date, person_id,
754: per_in_ler_id, total_score, object_version_number)
755: Select pqh_rank_processes_s.nextval, 'GSP', p_pgm_id, pl_id,
756: p_benefit_action_id, lf_evt_ocrd_dt ,
757: person_id, per_in_ler_id, total_score,1
758: FROM ( select pl_id, per_in_ler_id, person_id,
759: lf_evt_ocrd_dt, sum(GROUP_score) total_score

Line 797: INSERT INTO pqh_rank_processes (

793: ELSIF (p_group_score = 'GL' ) THEN
794: --
795: IF ( p_handle_duplicate = 'SUM') THEN
796: --
797: INSERT INTO pqh_rank_processes (
798: rank_process_id, process_cd, pgm_id,
799: benefit_action_id, process_date, person_id,
800: per_in_ler_id, total_score,object_version_number)
801: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id, p_benefit_action_id,

Line 801: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id, p_benefit_action_id,

797: INSERT INTO pqh_rank_processes (
798: rank_process_id, process_cd, pgm_id,
799: benefit_action_id, process_date, person_id,
800: per_in_ler_id, total_score,object_version_number)
801: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id, p_benefit_action_id,
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

Line 833: INSERT INTO pqh_rank_processes (

829: ) ;
830: --
831: ELSE
832: ---
833: INSERT INTO pqh_rank_processes (
834: rank_process_id, process_cd, pgm_id,
835: benefit_action_id, process_date, person_id,
836: per_in_ler_id, total_score, object_version_number)
837: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id,p_benefit_action_id,

Line 837: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id,p_benefit_action_id,

833: INSERT INTO pqh_rank_processes (
834: rank_process_id, process_cd, pgm_id,
835: benefit_action_id, process_date, person_id,
836: per_in_ler_id, total_score, object_version_number)
837: Select pqh_rank_processes_s.nextval, 'GSP', pgm_id,p_benefit_action_id,
838: lf_evt_ocrd_dt, person_id, per_in_ler_id, total_score,1
839: FROM ( select pgm_id, per_in_ler_id, person_id, lf_evt_ocrd_dt,
840: sum(GROUP_score) total_score
841: from (

Line 877: update pqh_rank_processes

873: END IF; -- group score
874: --
875: for i in per_asg_cur loop
876:
877: update pqh_rank_processes
878: set assignment_id = i.assignment_id
879: where person_id = p_person_id
880: and benefit_action_id = p_benefit_action_id
881: and pgm_id = p_pgm_id;

Line 923: Insert into pqh_rank_processes (

919: --
920: --
921: /** NS: 04/26/2005: Commenting as CWB Ranking is not going in FP.K
922: Will uncomment it when CWB is ready to ship system ranking
923: Insert into pqh_rank_processes (
924: Rank_process_id, process_cd, pl_id, person_id, assignment_id,
925: Process_date, total_score)
926: SELECT pqh_rank_processes_s.nextval,'CWB', group_pl_id, person_id, assignment_id,
927: lf_evt_ocrd_dt, total_score

Line 926: SELECT pqh_rank_processes_s.nextval,'CWB', group_pl_id, person_id, assignment_id,

922: Will uncomment it when CWB is ready to ship system ranking
923: Insert into pqh_rank_processes (
924: Rank_process_id, process_cd, pl_id, person_id, assignment_id,
925: Process_date, total_score)
926: SELECT pqh_rank_processes_s.nextval,'CWB', group_pl_id, person_id, assignment_id,
927: lf_evt_ocrd_dt, total_score
928: FROM (
929: Select pr.group_pl_id, pr.person_id, pr.assignment_id,
930: pr.lf_evt_ocrd_dt, sum(sr.score) total_score

Line 1071: from pqh_rank_processes rp,

1067: SELECT pqh_rank_process_approvals_s.NEXTVAL, rank_process_id, supervisor_id, system_rank,
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