APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_ROUTING_HISTORY

Line 218: FROM GHR_PA_ROUTING_HISTORY PRH,

214: AND pa_request_id = c_pa_request_id;
215:
216: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS
217: SELECT COUNT(*) cnt
218: FROM GHR_PA_ROUTING_HISTORY PRH,
219: PER_PEOPLE_F PER,
220: PER_ASSIGNMENTS_F ASG,
221: PER_POSITION_EXTRA_INFO PG1
222: WHERE PRH.pa_request_id = p_pa_request_id

Line 226: FROM GHR_PA_ROUTING_HISTORY P

222: WHERE PRH.pa_request_id = p_pa_request_id
223: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
224: AND PRH.user_name_employee_id = PER.person_id
225: AND PRH.LAST_UPDATE_DATE = (SELECT MAX(P.last_update_date)
226: FROM GHR_PA_ROUTING_HISTORY P
227: WHERE P.pa_request_id = PRH.pa_request_id
228: AND (P.personnelist_flag = 'Y' OR P.approver_flag = 'Y')
229: AND P.user_name_employee_id = PRH.user_name_employee_id)
230: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN PER.effective_start_date AND PER.effective_end_date

Line 242: FROM GHR_PA_ROUTING_HISTORY PRH,

238: CURSOR C_SIGNATURES (p_pa_request_id ghr_pa_requests.pa_request_id%type, p_effective_date DATE) IS
239: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
240: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
241: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
242: FROM GHR_PA_ROUTING_HISTORY PRH,
243: PER_PEOPLE_F PER,
244: PER_ASSIGNMENTS_F ASG,
245: PER_POSITION_EXTRA_INFO PG1
246: WHERE PRH.pa_request_id = p_pa_request_id

Line 250: FROM GHR_PA_ROUTING_HISTORY P

246: WHERE PRH.pa_request_id = p_pa_request_id
247: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
248: AND PRH.user_name_employee_id = PER.person_id
249: AND PRH.LAST_UPDATE_DATE = (SELECT MAX(P.last_update_date)
250: FROM GHR_PA_ROUTING_HISTORY P
251: WHERE P.pa_request_id = PRH.pa_request_id
252: AND (P.personnelist_flag = 'Y' OR P.approver_flag = 'Y')
253: AND P.user_name_employee_id = PRH.user_name_employee_id)
254: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN PER.effective_start_date AND PER.effective_end_date