[Home] [Help]
189: the employee in 'US GROSS TO NET SUMMARY REPORT' who has
190: 'Balance Adjustments' or 'Balance Initializations' alone in the pay period. */
191:
192: sqlstr := 'select distinct asg.person_id
193: from per_assignments_f asg,
194: pay_assignment_actions act_run, /* run and quickpay assignment actions */
195: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
196: pay_payroll_actions ppa_gen /* PYUGEN information */
197: where ppa_gen.payroll_action_id = :payroll_action_id
251: ) is
252: select /*+ ORDERED
253: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
254: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
255: INDEX (asg PER_ASSIGNMENTS_F_PK) */
256: ppa_run.action_type,
257: act_run.assignment_action_id,
258: asg.assignment_id,
259: act_run.tax_unit_id
258: asg.assignment_id,
259: act_run.tax_unit_id
260: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
261: pay_assignment_actions act_run, /* run and quickpay assignment actions */
262: per_assignments_f asg
263: where ppa_run.effective_date between
264: l_start_date
265: and l_effective_date
266: and ppa_run.action_type in ('R','Q','V','B') /* 8216159 */
457: ) is
458: select /*+ ORDERED
459: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
460: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
461: INDEX (asg PER_ASSIGNMENTS_F_PK) */
462: ppa_run.action_type,
463: act_run.assignment_action_id,
464: asg.assignment_id,
465: act_run.tax_unit_id
464: asg.assignment_id,
465: act_run.tax_unit_id
466: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
467: pay_assignment_actions act_run, /* run and quickpay assignment actions */
468: per_assignments_f asg
469: where ppa_run.effective_date between
470: l_start_date
471: and l_effective_date
472: and ppa_run.action_type in ('R','Q','V')