[Home] [Help]
394: from pay_element_types_f pet,
395: pay_input_values_f piv,
396: pay_run_results prr,
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments
399: pay_assignment_actions rpaa, -- Assignment Action of Run
400: pay_action_interlocks pai,
401: pay_payroll_actions ppa -- Payroll Action of Prepayments
402: where pet.element_type_id = prr.element_type_id
395: pay_input_values_f piv,
396: pay_run_results prr,
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments
399: pay_assignment_actions rpaa, -- Assignment Action of Run
400: pay_action_interlocks pai,
401: pay_payroll_actions ppa -- Payroll Action of Prepayments
402: where pet.element_type_id = prr.element_type_id
403: and piv.element_type_id = pet.element_type_id
2005: select paa_run.assignment_id assignment_id,
2006: paa_run.assignment_action_id run_action_id,
2007: paa_pre.assignment_action_id prepaid_action_id
2008: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2008: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2014: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2015: where ppa_arch.payroll_action_id = p_pact_id
2016: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run
2033: and not exists -- You can comment this to make the Archive rerunable
2034: (
2035: select /*+ ORDERED */ NULL
2036: from pay_action_interlocks pai2,
2037: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver
2038: pay_payroll_actions ppa_arch2 -- Payroll Action of Archiver
2039: where pai2.locked_action_id = paa_run.assignment_action_id
2040: and paa_arch2.assignment_action_id = pai2.locking_action_id
2041: and paa_arch2.payroll_action_id = ppa_arch2.payroll_action_id
2130:
2131: if l_prepay_action_id <> csr_rec.prepaid_action_id then
2132:
2133: -- Select the next Assignment Action ID
2134: select pay_assignment_actions_s.nextval
2135: into l_actid
2136: from dual;
2137:
2138: -- retrieve the tax_unit_id
2188: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run
2193: pay_assignment_actions passact -- Assignment Action of Archiver
2194: where pre.locked_action_id = pay.locking_action_id
2195: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver
2196: and pre.locked_action_id = passact.assignment_action_id
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run
2193: pay_assignment_actions passact -- Assignment Action of Archiver
2194: where pre.locked_action_id = pay.locking_action_id
2195: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver
2196: and pre.locked_action_id = passact.assignment_action_id
2197: and passact.payroll_action_id = ppaa.payroll_action_id
2212: p_effective_date date
2213: ) is
2214: select paa.assignment_action_id child_assignment_action_id,
2215: 'S' run_type -- Separate Payment Run
2216: from pay_assignment_actions paa, -- Assignment Action of Child Run
2217: pay_run_types_f prt
2218: where paa.source_action_id = p_master_assignment_action -- Assignment Action of Master Run
2219: and paa.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2220: and paa.assignment_id = p_assignment_id
2223: and p_effective_date between prt.effective_start_date and prt.effective_end_date
2224: union
2225: select paa.assignment_action_id child_assignment_action_id,
2226: 'NP' run_type -- Standard Run, Process Separate Run
2227: from pay_assignment_actions paa
2228: where paa.payroll_action_id = p_payroll_action_id
2229: and paa.assignment_id = p_assignment_id
2230: and paa.action_sequence =
2231: (
2229: and paa.assignment_id = p_assignment_id
2230: and paa.action_sequence =
2231: (
2232: select max(paa1.action_sequence)
2233: from pay_assignment_actions paa1,
2234: pay_run_types_f prt1
2235: where prt1.run_type_id = paa1.run_type_id
2236: and prt1.run_method in ('N', 'P')
2237: and paa1.payroll_action_id = p_payroll_action_id -- Payroll Action of Master Run
2248: p_effective_date date
2249: ) is
2250: select paa.assignment_action_id np_assignment_action_id,
2251: prt.run_method
2252: from pay_assignment_actions paa,
2253: pay_run_types_f prt
2254: where paa.source_action_id = p_assignment_action_id
2255: and paa.payroll_action_id = p_payroll_action_id
2256: and paa.assignment_id = p_assignment_id
2291:
2292: -- Retrieve the chunk number for the current assignment action
2293: select paa.chunk_number
2294: into l_chunk_number
2295: from pay_assignment_actions paa
2296: where paa.assignment_action_id = p_assactid;
2297:
2298: l_action_context_id := p_assactid; --Assignment Action of Archiver
2299: