APPS.GHR_GEN_RPA_NPA dependencies on PER_POSITION_EXTRA_INFO

Line 221: PER_POSITION_EXTRA_INFO PG1

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
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)

Line 245: PER_POSITION_EXTRA_INFO PG1

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
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)

Line 2068: l_pos_ei_data per_position_extra_info%rowtype;

2064: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
2065: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
2066: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
2067: l_to_organization_id per_assignments_f.organization_id%TYPE;
2068: l_pos_ei_data per_position_extra_info%rowtype;
2069: l_poi VARCHAR2(30);
2070:
2071: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
2072: SELECT ppi.ppi_percentage