[Home] [Help]
161: *** 17 Mar 05 ksingla 115.141 Bug#4177679 Modified the subquery of employee_details to archive correct employee le_start_date
162: when person details are modified .
163: *** 31 Mar 05 ksingla 115.142 Bug#4177679 Modified the subquery of employee_details to archive correct employee le_end_date
164: when "Leave Loading" segment is modified.
165: *** 11 Apr 05 ksingla 115.143 Bug#4278361 Modified the cursor etp_paid. Added a new table pay_payrolls_f for performance issues.
166: *** 12 Apr 05 avenkatk 115.144 Bug#4299506 Modified Cursor employee_details - Sub Query modified to archive employee details for employees terminated in previous year.
167: *** 13 Apr 05 ksingla 115.145 Bug#4278379 Modified the cursor get_retro_entry_ids for performance.
168: *** 14 Apr 05 ksingla 115.146 Bug#4278379 Rolled back the changes done to cursor get_retro_entry_ids.
169: *** 18 Apr 05 ksingla 115.147 Bug#4278299 Modified the cursor get_allowance_balances for performance.
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv
2267: ,pay_assignment_actions pac
2268: ,pay_payroll_actions ppa
2269: ,pay_payrolls_f papf /* bug Number 4278361 */
2270: where pet.element_type_id = piv.element_type_id
2271: and pet.element_name = 'ETP on Termination'
2272: and piv.name = 'Pay ETP Components'
2273: and paa.assignment_id = c_assignment_id
3930: CURSOR c_get_payroll_name
3931: IS
3932: SELECT pay.payroll_name
3933: FROM per_all_assignments_f paaf,
3934: pay_payrolls_f pay
3935: WHERE paaf.assignment_id = p_assignment_id
3936: and paaf.effective_end_date = (select max(effective_end_date)
3937: From per_assignments_f iipaf
3938: WHERE iipaf.assignment_id = p_assignment_id