[Home] [Help]
4924: --
4925: -- then Mark for Retry the assignment action
4926: --
4927: /* -- irrelevant, commented out.
4928: update pay_assignment_actions paa
4929: set paa.action_status = 'M'
4930: where paa.assignment_action_id =
4931: (select aa.assignment_action_id
4932: from pay_assignment_actions aa,
4928: update pay_assignment_actions paa
4929: set paa.action_status = 'M'
4930: where paa.assignment_action_id =
4931: (select aa.assignment_action_id
4932: from pay_assignment_actions aa,
4933: pay_payroll_actions pa,
4934: per_assignments_f asg,
4935: per_time_periods tim,
4936: pay_payrolls_f pp
4936: pay_payrolls_f pp
4937: where pa.effective_date =
4938: (select max(pa2.effective_date)
4939: from pay_payroll_actions pa2,
4940: pay_assignment_actions aa2
4941: where aa2.assignment_id = p_assignment_id
4942: and pa2.payroll_action_id = aa2.payroll_action_id)
4943: and pa.action_sequence =
4944: (select max(pa3.action_sequence)
4942: and pa2.payroll_action_id = aa2.payroll_action_id)
4943: and pa.action_sequence =
4944: (select max(pa3.action_sequence)
4945: from pay_payroll_actions pa3,
4946: pay_assignment_actions aa3
4947: where aa3.assignment_id = p_assignment_id
4948: and pa3.payroll_action_id = aa3.payroll_action_id
4949: and pa3.effective_date = pa.effective_date)
4950: and not exists
4949: and pa3.effective_date = pa.effective_date)
4950: and not exists
4951: (select null
4952: from pay_payroll_actions pa4,
4953: pay_assignment_actions aa4
4954: where aa4.assignment_id = p_assignment_id
4955: and aa4.payroll_action_id = pa4.payroll_action_id
4956: and pa4.action_type = 'R'
4957: and pa4.action_sequence < pa.action_sequence
5708: begin
5709: select max(ppr.run_result_id)
5710: into l_run_result_id
5711: from pay_run_results ppr,
5712: pay_assignment_actions paa,
5713: pay_payroll_actions ppa,
5714: pay_action_classifications pac
5715: where ppr.source_id = p_element_entry_id
5716: and ppr.source_type = 'E'