APPS.PAY_PAYGTN_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 194: pay_assignment_actions act_run, /* run and quickpay assignment actions */

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
198: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */

Line 254: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)

250: endperson number
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,

Line 261: pay_assignment_actions act_run, /* run and quickpay assignment actions */

257: act_run.assignment_action_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

Line 399: select pay_assignment_actions_s.nextval

395:
396: null;
397: else
398: hr_utility.set_location('procpyr',3);
399: select pay_assignment_actions_s.nextval
400: into lockingactid
401: from dual;
402: --
403: -- insert the action record.

Line 460: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)

456: endperson number
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,

Line 467: pay_assignment_actions act_run, /* run and quickpay assignment actions */

463: act_run.assignment_action_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

Line 605: select pay_assignment_actions_s.nextval

601:
602: null;
603: else
604: hr_utility.set_location('procpyr',3);
605: select pay_assignment_actions_s.nextval
606: into lockingactid
607: from dual;
608: --
609: -- insert the action record.

Line 630: from pay_assignment_actions paa1, -- PYUGEN assignment action

626: ) is
627: begin
628:
629: sqlstr := 'select paa1.rowid
630: from pay_assignment_actions paa1, -- PYUGEN assignment action
631: pay_payroll_actions ppa1 -- PYUGEN payroll action id
632: where ppa1.payroll_action_id = :pactid
633: and paa1.payroll_action_id = ppa1.payroll_action_id
634: order by paa1.assignment_action_id