APPS.PQH_RANK_UTILITY dependencies on PQH_RANK_PROCESS_APPROVALS

Line 105: ,pqh_rank_process_approvals rpa

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;
109:

Line 115: ,pqh_rank_process_approvals rpa

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
119: and rp.pl_id = p_pl_id ;

Line 182: ,pqh_rank_process_approvals rpa

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
186: and rp.rank_process_id = rpa.rank_process_id;

Line 193: ,pqh_rank_process_approvals rpa

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
197: and rp.rank_process_id = rpa.rank_process_id

Line 256: ,pqh_rank_process_approvals rpa

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;
260:

Line 264: ,pqh_rank_process_approvals rpa

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 ;

Line 273: ,pqh_rank_process_approvals rpa

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;
277:

Line 281: ,pqh_rank_process_approvals rpa

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
285: and rp.pl_id = p_pl_id ;