[Home] [Help]
73: 26-Nov-2005 sackumar 115.14 4742901 Modified the c_paid_actions cursor query in
74: action_creation procedure to resolve the
75: performance issues.
76: 16-Dec-2005 tclewis 115.15 added code to check for the existance of data in the
77: pay_action_information table. thie is to fix a problem
78: with the zero (gross, net) pay assignment being picked up
79: by in the archive_action_creation procedure.
80: 23-Jan-2006 sackumar 115.18 4945604 Modified the C_action_asg_set Cursor in action_creation procedure
81: 24-May-2007 sudedas 115.21 5635335 Procedure archive_deinit has
551: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id
552: and ppa_rev.action_type in ('V')
553: )
554: and exists ( select 1
555: from pay_action_information pai
556: where pai.action_context_id = paa_xfr.assignment_action_id
557: and rownum < 2
558: ) order by paa_xfr.assignment_id desc;
559:
1161: ,pai.action_context_id
1162: FROM pay_assignment_actions paa
1163: ,pay_payroll_actions ppa
1164: ,hr_lookups hrl
1165: ,pay_action_information pai
1166: ,per_time_periods ptp
1167: WHERE /* paa.assignment_id = c_assignment_id */
1168: ppa.effective_Date BETWEEN c_start_date
1169: AND c_end_date
1207: FROM pay_assignment_actions paa
1208: ,pay_payroll_actions ppa
1209: ,hr_lookups hrl
1210: ,hr_assignment_set_amendments hasa
1211: ,pay_action_information pai
1212: ,per_time_periods ptp
1213: WHERE ppa.effective_Date BETWEEN c_start_date
1214: AND c_end_date
1215: AND ppa.report_type = hrl.meaning