[Home] [Help]
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
173: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
174: AND PRH.user_name_employee_id = PER.person_id
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
197: AND (PRH.personnelist_flag = 'Y' OR PRH.approver_flag = 'Y')
198: AND PRH.user_name_employee_id = PER.person_id
1094: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
1095: l_mddds_special_pay_amount ghr_pa_requests.to_total_salary%TYPE;
1096: l_to_avail_pay ghr_pa_requests.to_availability_pay%TYPE;
1097: l_to_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
1098: l_to_organization_id per_assignments_f.organization_id%TYPE;
1099:
1100: CURSOR c_percentage_ppi(p_ppi_code ghr_premium_pay_indicators.code%TYPE) IS
1101: SELECT ppi.ppi_percentage
1102: FROM ghr_premium_pay_indicators ppi
1747: l_ppi_percentage ghr_premium_pay_indicators.ppi_percentage%TYPE;
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