APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_ROUTING_HISTORY

Line 168: FROM GHR_PA_ROUTING_HISTORY PRH,

164: AND pa_request_id = c_pa_request_id;
165:
166: CURSOR C_CNT_SIGS (p_pa_request_id NUMBER, p_effective_date DATE) IS
167: SELECT COUNT(*) cnt
168: FROM GHR_PA_ROUTING_HISTORY PRH,
169: PER_PEOPLE_F PER,
170: PER_ASSIGNMENTS_F ASG,
171: PER_POSITION_EXTRA_INFO PG1
172: WHERE PRH.pa_request_id = p_pa_request_id

Line 176: FROM GHR_PA_ROUTING_HISTORY P

172: WHERE PRH.pa_request_id = p_pa_request_id
173: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
174: AND PRH.user_name_employee_id = PER.person_id
175: AND PRH.LAST_UPDATE_DATE = (SELECT MAX(P.last_update_date)
176: FROM GHR_PA_ROUTING_HISTORY P
177: WHERE P.pa_request_id = PRH.pa_request_id
178: AND (P.personnelist_flag = 'Y' OR P.approver_flag = 'Y')
179: AND P.user_name_employee_id = PRH.user_name_employee_id)
180: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN PER.effective_start_date AND PER.effective_end_date

Line 192: FROM GHR_PA_ROUTING_HISTORY PRH,

188: CURSOR C_SIGNATURES (p_pa_request_id ghr_pa_requests.pa_request_id%type, p_effective_date DATE) IS
189: SELECT PG1.POEI_INFORMATION4 Office_Symbol,
190: PER.LAST_NAME || ', ' || PER.FIRST_NAME || ' ' || PER.MIDDLE_NAMES FULL_NAME,
191: TO_CHAR(PRH.LAST_UPDATE_DATE, 'MM-DD-YYYY') LAST_UPDATE_DATE
192: FROM GHR_PA_ROUTING_HISTORY PRH,
193: PER_PEOPLE_F PER,
194: PER_ASSIGNMENTS_F ASG,
195: PER_POSITION_EXTRA_INFO PG1
196: WHERE PRH.pa_request_id = p_pa_request_id

Line 200: FROM GHR_PA_ROUTING_HISTORY P

196: WHERE PRH.pa_request_id = p_pa_request_id
197: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
198: AND PRH.user_name_employee_id = PER.person_id
199: AND PRH.LAST_UPDATE_DATE = (SELECT MAX(P.last_update_date)
200: FROM GHR_PA_ROUTING_HISTORY P
201: WHERE P.pa_request_id = PRH.pa_request_id
202: AND (P.personnelist_flag = 'Y' OR P.approver_flag = 'Y')
203: AND P.user_name_employee_id = PRH.user_name_employee_id)
204: AND NVL(p_effective_date, TRUNC(sysdate)) BETWEEN PER.effective_start_date AND PER.effective_end_date