APPS.PAY_PAYGTN_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

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

181: /* pay gtn code */
182:
183: sqlstr := 'select distinct asg.person_id
184: from per_assignments_f asg,
185: pay_assignment_actions act_run, /* run and quickpay assignment actions */
186: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
187: pay_payroll_actions ppa_gen /* PYUGEN information */
188: where ppa_gen.payroll_action_id = :payroll_action_id
189: and ppa_run.effective_date between /* date join btwn run and pyugen ppa */

Line 245: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)

241: endperson number
242: ) is
243: select /*+ ORDERED
244: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
245: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
246: INDEX (asg PER_ASSIGNMENTS_F_PK) */
247: ppa_run.action_type,
248: act_run.assignment_action_id,
249: asg.assignment_id,

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

248: act_run.assignment_action_id,
249: asg.assignment_id,
250: act_run.tax_unit_id
251: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
252: pay_assignment_actions act_run, /* run and quickpay assignment actions */
253: per_assignments_f asg
254: where ppa_run.effective_date between
255: l_start_date
256: and l_effective_date

Line 390: select pay_assignment_actions_s.nextval

386:
387: null;
388: else
389: hr_utility.set_location('procpyr',3);
390: select pay_assignment_actions_s.nextval
391: into lockingactid
392: from dual;
393: --
394: -- insert the action record.

Line 451: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)

447: endperson number
448: ) is
449: select /*+ ORDERED
450: INDEX (ppa_gen PAY_PAYROLL_ACTIONS_PK)
451: INDEX (act_run PAY_ASSIGNMENT_ACTIONS_N50)
452: INDEX (asg PER_ASSIGNMENTS_F_PK) */
453: ppa_run.action_type,
454: act_run.assignment_action_id,
455: asg.assignment_id,

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

454: act_run.assignment_action_id,
455: asg.assignment_id,
456: act_run.tax_unit_id
457: from pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
458: pay_assignment_actions act_run, /* run and quickpay assignment actions */
459: per_assignments_f asg
460: where ppa_run.effective_date between
461: l_start_date
462: and l_effective_date

Line 596: select pay_assignment_actions_s.nextval

592:
593: null;
594: else
595: hr_utility.set_location('procpyr',3);
596: select pay_assignment_actions_s.nextval
597: into lockingactid
598: from dual;
599: --
600: -- insert the action record.

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

617: ) is
618: begin
619:
620: sqlstr := 'select paa1.rowid
621: from pay_assignment_actions paa1, -- PYUGEN assignment action
622: pay_payroll_actions ppa1 -- PYUGEN payroll action id
623: where ppa1.payroll_action_id = :pactid
624: and paa1.payroll_action_id = ppa1.payroll_action_id
625: order by paa1.assignment_action_id