[Home] [Help]
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
223: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
224: AND PRH.user_name_employee_id = PER.person_id
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
247: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
248: AND PRH.user_name_employee_id = PER.person_id
1321: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1322: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1323: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1324: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1325: l_to_organization_id per_assignments_f.organization_id%TYPE;
1326:
1327: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1328: SELECT ppi.ppi_percentage
1329: FROM ghr_premium_pay_indicators ppi
2063: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
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