[Home] [Help]
255: 29-JAN-2004 rsethupa 115.55 3370112 11.5.10 Performance Changes
256: Modified cursor c_cur_action_elements
257: by removing the 'and exists' clause
258: 28-JAN-2004 rsethupa 115.54 3370112 11.5.10 Performance Changes
259: 14-JAN-2003 RMONGE 115.53 3360805 Remove hr. from pay_action_information
260: 25-NOV-2003 vpandya 115.52 3280589 Changed get_xfr_elements:
261: modified cursor c_last_per_xfr_run.
262: 07-NOV-2003 vpandya 115.51 3225286 Changed c_prev_ytd_action_elements
263: cursor and added condition for
267: (ytd_hours) and initializing
268: variable ln_ytd_hours.
269: 04-NOV-2003 vpandya 115.49 3228457 Changed c_last_per_xfr_run cursor:
270: Remove extra table
271: pay_action_information.
272: 20-OCT-2003 vpandya 115.48 3119792 Changed process_additional_elements:
273: calling populate_summary to archive
274: summary for YTD.
275: 04-OCT-2003 ahanda 115.47 3107166 Added date joins when getting
706: ,cp_xfr_action_id in number
707: ,cp_effective_date in date) is
708: select pai.effective_date,
709: pai.action_context_id
710: from pay_action_information pai
711: where pai.action_context_type = 'AAP'
712: and pai.assignment_id = cp_assignment_id
713: and pai.action_information_category = cp_action_info_category
714: and pai.action_context_id <> cp_xfr_action_id
720: cp_assignment_id in number
721: ,cp_action_info_category in varchar2
722: ,cp_xfr_action_id in number
723: ,cp_effective_date in date) is
724: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
725: pai.action_context_id
726: from per_all_assignments_f paf2
727: ,per_all_assignments_f paf
728: ,pay_action_information pai
724: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
725: pai.action_context_id
726: from per_all_assignments_f paf2
727: ,per_all_assignments_f paf
728: ,pay_action_information pai
729: where paf2.assignment_id = cp_assignment_id
730: and paf.person_id = paf2.person_id
731: and pai.assignment_id = paf.assignment_id
732: and pai.action_context_type = 'AAP'
850: ,cp_xfr_action_id in number
851: ,cp_effective_date in date) is
852: select pai.effective_date,
853: pai.action_context_id
854: from pay_action_information pai
855: where pai.action_context_type = 'AAP'
856: and pai.assignment_id = cp_assignment_id
857: and pai.action_information_category = cp_action_info_category
858: and pai.action_context_id <> cp_xfr_action_id
865: ,cp_action_info_category in varchar2
866: ,cp_xfr_action_id in number
867: ,cp_payroll_id in number -- added for the bug 14605761
868: ,cp_effective_date in date) is
869: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
870: pai.action_context_id
871: from per_all_assignments_f paf2
872: ,per_all_assignments_f paf
873: ,pay_action_information pai
869: select /*+ index(PAI PAY_ACTION_INFORMATION_N5) */ pai.effective_date,
870: pai.action_context_id
871: from per_all_assignments_f paf2
872: ,per_all_assignments_f paf
873: ,pay_action_information pai
874: where paf2.assignment_id = cp_assignment_id
875: and paf.person_id = paf2.person_id
876: and pai.assignment_id = paf.assignment_id
877: and paf.payroll_id = cp_payroll_id --condition added for the bug 14605761
3045: action_information10 reporting_name,
3046: effective_date effective_date,
3047: action_information12 ytd_hours,
3048: action_information24 display_name
3049: from pay_action_information
3050: where action_information_category in ('AC EARNINGS', 'AC DEDUCTIONS')
3051: and action_context_id = cp_xfr_action_id;
3052:
3053: