[Home] [Help]
5300: --
5301: -- then Mark for Retry the assignment action
5302: --
5303: /* -- irrelevant, commented out.
5304: update pay_assignment_actions paa
5305: set paa.action_status = 'M'
5306: where paa.assignment_action_id =
5307: (select aa.assignment_action_id
5308: from pay_assignment_actions aa,
5304: update pay_assignment_actions paa
5305: set paa.action_status = 'M'
5306: where paa.assignment_action_id =
5307: (select aa.assignment_action_id
5308: from pay_assignment_actions aa,
5309: pay_payroll_actions pa,
5310: per_assignments_f asg,
5311: per_time_periods tim,
5312: pay_payrolls_f pp
5312: pay_payrolls_f pp
5313: where pa.effective_date =
5314: (select max(pa2.effective_date)
5315: from pay_payroll_actions pa2,
5316: pay_assignment_actions aa2
5317: where aa2.assignment_id = p_assignment_id
5318: and pa2.payroll_action_id = aa2.payroll_action_id)
5319: and pa.action_sequence =
5320: (select max(pa3.action_sequence)
5318: and pa2.payroll_action_id = aa2.payroll_action_id)
5319: and pa.action_sequence =
5320: (select max(pa3.action_sequence)
5321: from pay_payroll_actions pa3,
5322: pay_assignment_actions aa3
5323: where aa3.assignment_id = p_assignment_id
5324: and pa3.payroll_action_id = aa3.payroll_action_id
5325: and pa3.effective_date = pa.effective_date)
5326: and not exists
5325: and pa3.effective_date = pa.effective_date)
5326: and not exists
5327: (select null
5328: from pay_payroll_actions pa4,
5329: pay_assignment_actions aa4
5330: where aa4.assignment_id = p_assignment_id
5331: and aa4.payroll_action_id = pa4.payroll_action_id
5332: and pa4.action_type = 'R'
5333: and pa4.action_sequence < pa.action_sequence
6097: begin
6098: select max(ppr.run_result_id)
6099: into l_run_result_id
6100: from pay_run_results ppr,
6101: pay_assignment_actions paa,
6102: pay_payroll_actions ppa,
6103: pay_action_classifications pac
6104: where ppr.source_id = p_element_entry_id
6105: and ppr.source_type = 'E'