APPS.GHR_GEN_RPA_NPA dependencies on PER_POSITION_EXTRA_INFO

Line 171: PER_POSITION_EXTRA_INFO PG1

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

Line 195: PER_POSITION_EXTRA_INFO PG1

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

Line 1752: l_pos_ei_data per_position_extra_info%rowtype;

1748: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1749: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1750: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1751: l_to_organization_id per_assignments_f.organization_id%TYPE;
1752: l_pos_ei_data per_position_extra_info%rowtype;
1753: l_poi VARCHAR2(30);
1754:
1755: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1756: SELECT ppi.ppi_percentage