[Home] [Help]
39: l_ben_action_id number ;
40: l_gl_option varchar2(80) ;
41: cursor csr_for_group_gl is
42: select rp.benefit_action_id
43: from pqh_rank_processes rp
44: where rp.pgm_id = p_pgm_id
45: and rp.per_in_ler_id = p_per_in_ler_id;
46:
47: cursor csr_for_group_grade is
45: and rp.per_in_ler_id = p_per_in_ler_id;
46:
47: cursor csr_for_group_grade is
48: select rp.benefit_action_id
49: from pqh_rank_processes rp
50: where rp.pgm_id = p_pgm_id
51: and rp.per_in_ler_id = p_per_in_ler_id
52: and rp.pl_id = p_pl_id ;
53: begin
100: cursor csr_for_group_gl is
101: select rpa.rank_process_approval_id
102: ,rpa.rank_process_id
103: ,rpa.object_version_number
104: from pqh_rank_processes rp
105: ,pqh_rank_process_approvals rpa
106: where rp.pgm_id = p_pgm_id
107: and rp.per_in_ler_id = p_per_in_ler_id
108: and rp.rank_process_id = rpa.rank_process_id;
110: cursor csr_for_group_grade is
111: select rpa.rank_process_approval_id
112: ,rpa.rank_process_id
113: ,rpa.object_version_number
114: from pqh_rank_processes rp
115: ,pqh_rank_process_approvals rpa
116: where rp.pgm_id = p_pgm_id
117: and rp.per_in_ler_id = p_per_in_ler_id
118: and rp.rank_process_id = rpa.rank_process_id
177: cursor csr_for_group_gl is
178: select rpa.rank_process_approval_id
179: ,rpa.rank_process_id
180: ,rpa.object_version_number
181: from pqh_rank_processes rp
182: ,pqh_rank_process_approvals rpa
183: where rp.pgm_id = p_pgm_id
184: and rp.assignment_id = p_assignment_id
185: and rp.PROCESS_DATE = p_life_event_dt
188: cursor csr_for_group_grade is
189: select rpa.rank_process_approval_id
190: ,rpa.rank_process_id
191: ,rpa.object_version_number
192: from pqh_rank_processes rp
193: ,pqh_rank_process_approvals rpa
194: where rp.pgm_id = p_pgm_id
195: and rp.assignment_id = p_assignment_id
196: and rp.PROCESS_DATE = p_life_event_dt
251: l_gl_option varchar2(80) ;
252:
253: cursor csr_for_grp_gl_sys_rank is
254: select rpa.system_rank
255: from pqh_rank_processes rp
256: ,pqh_rank_process_approvals rpa
257: where rp.pgm_id = p_pgm_id
258: and rp.per_in_ler_id = p_per_in_ler_id
259: and rp.rank_process_id = rpa.rank_process_id;
259: and rp.rank_process_id = rpa.rank_process_id;
260:
261: cursor csr_for_grp_grade_sys_rank is
262: select rpa.system_rank
263: from pqh_rank_processes rp
264: ,pqh_rank_process_approvals rpa
265: where rp.pgm_id = p_pgm_id
266: and rp.per_in_ler_id = p_per_in_ler_id
267: and rp.rank_process_id = rpa.rank_process_id
268: and rp.pl_id = p_pl_id ;
269:
270: cursor csr_for_grp_gl_pro_rank is
271: select rpa.proposed_rank
272: from pqh_rank_processes rp
273: ,pqh_rank_process_approvals rpa
274: where rp.pgm_id = p_pgm_id
275: and rp.per_in_ler_id = p_per_in_ler_id
276: and rp.rank_process_id = rpa.rank_process_id;
276: and rp.rank_process_id = rpa.rank_process_id;
277:
278: cursor csr_for_grp_grade_pro_rank is
279: select rpa.proposed_rank
280: from pqh_rank_processes rp
281: ,pqh_rank_process_approvals rpa
282: where rp.pgm_id = p_pgm_id
283: and rp.per_in_ler_id = p_per_in_ler_id
284: and rp.rank_process_id = rpa.rank_process_id
346: l_total_score number ;
347: l_gl_option varchar2(80) ;
348: cursor csr_for_group_gl is
349: select rp.total_score
350: from pqh_rank_processes rp
351: where rp.pgm_id = p_pgm_id
352: and rp.per_in_ler_id = p_per_in_ler_id;
353:
354: cursor csr_for_group_grade is
352: and rp.per_in_ler_id = p_per_in_ler_id;
353:
354: cursor csr_for_group_grade is
355: select rp.total_score
356: from pqh_rank_processes rp
357: where rp.pgm_id = p_pgm_id
358: and rp.per_in_ler_id = p_per_in_ler_id
359: and rp.pl_id = p_pl_id ;
360: begin