[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
558: and ppa_rev.payroll_action_id = paa_rev.payroll_action_id
559: and ppa_rev.action_type in ('V')
560: )
561: and exists ( select 1
562: from pay_action_information pai
563: where pai.action_context_id = paa_xfr.assignment_action_id
564: and rownum < 2
565: ) order by paa_xfr.assignment_id desc;
566:
1171: ,pai.action_context_id
1172: FROM pay_assignment_actions paa
1173: ,pay_payroll_actions ppa
1174: ,hr_lookups hrl
1175: ,pay_action_information pai
1176: ,per_time_periods ptp
1177: WHERE /* paa.assignment_id = c_assignment_id */
1178: ppa.effective_Date BETWEEN c_start_date
1179: AND c_end_date
1217: FROM pay_assignment_actions paa
1218: ,pay_payroll_actions ppa
1219: ,hr_lookups hrl
1220: ,hr_assignment_set_amendments hasa
1221: ,pay_action_information pai
1222: ,per_time_periods ptp
1223: WHERE ppa.effective_Date BETWEEN c_start_date
1224: AND c_end_date
1225: AND ppa.report_type = hrl.meaning