[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.
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv
4446: ,pay_assignment_actions pac
4447: ,pay_payroll_actions ppa
4448: ,pay_payrolls_f papf /* bug Number 4278361 */
4449: where pet.element_type_id = piv.element_type_id
4450: and pet.element_name = 'ETP on Termination'
4451: and piv.name = 'Pay ETP Components'
4452: and paa.assignment_id = c_assignment_id
5996: FROM pay_run_results prr
5997: ,per_all_assignments_f paaf
5998: ,pay_assignment_actions pac
5999: ,pay_payroll_actions ppa
6000: ,pay_payrolls_f papf
6001: ,pay_element_types_f pet
6002: WHERE pac.assignment_id = p_assignment_id
6003: AND pac.assignment_action_id = prr.assignment_action_id
6004: AND pac.tax_unit_id = p_registered_employer
7375: CURSOR c_get_payroll_name
7376: IS
7377: SELECT pay.payroll_name
7378: FROM per_all_assignments_f paaf,
7379: pay_payrolls_f pay
7380: WHERE paaf.assignment_id = p_assignment_id
7381: and paaf.effective_end_date = (select max(effective_end_date)
7382: From per_assignments_f iipaf
7383: WHERE iipaf.assignment_id = p_assignment_id