[Home] [Help]
166: 29-JAN-2004 rsethupa 115.55 3370112 11.5.10 Performance Changes
167: Modified cursor c_cur_action_elements
168: by removing the 'and exists' clause
169: 28-JAN-2004 rsethupa 115.54 3370112 11.5.10 Performance Changes
170: 14-JAN-2003 RMONGE 115.53 3360805 Remove hr. from pay_action_information
171: 25-NOV-2003 vpandya 115.52 3280589 Changed get_xfr_elements:
172: modified cursor c_last_per_xfr_run.
173: 07-NOV-2003 vpandya 115.51 3225286 Changed c_prev_ytd_action_elements
174: cursor and added condition for
178: (ytd_hours) and initializing
179: variable ln_ytd_hours.
180: 04-NOV-2003 vpandya 115.49 3228457 Changed c_last_per_xfr_run cursor:
181: Remove extra table
182: pay_action_information.
183: 20-OCT-2003 vpandya 115.48 3119792 Changed process_additional_elements:
184: calling populate_summary to archive
185: summary for YTD.
186: 04-OCT-2003 ahanda 115.47 3107166 Added date joins when getting
621: ,cp_xfr_action_id in number
622: ,cp_effective_date in date) is
623: select pai.effective_date,
624: pai.action_context_id
625: from pay_action_information pai
626: where pai.action_context_type = 'AAP'
627: and pai.assignment_id = cp_assignment_id
628: and pai.action_information_category = cp_action_info_category
629: and pai.action_context_id <> cp_xfr_action_id
639: select pai.effective_date,
640: pai.action_context_id
641: from per_all_assignments_f paf2
642: ,per_all_assignments_f paf
643: ,pay_action_information pai
644: where paf2.assignment_id = cp_assignment_id
645: and paf.person_id = paf2.person_id
646: and pai.assignment_id = paf.assignment_id
647: and pai.action_context_type = 'AAP'
2561: action_information9 ytd_amount,
2562: action_information10 reporting_name,
2563: effective_date effective_date,
2564: action_information12 ytd_hours
2565: from pay_action_information
2566: where action_information_category in ('AC EARNINGS', 'AC DEDUCTIONS')
2567: and action_context_id = cp_xfr_action_id;
2568:
2569: