APPS.PAY_PAYGTN_PKG dependencies on PER_ASSIGNMENTS_F

Line 184: from per_assignments_f asg,

180:
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

Line 246: INDEX (asg PER_ASSIGNMENTS_F_PK) */

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,
250: act_run.tax_unit_id

Line 253: per_assignments_f asg

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
257: and ppa_run.action_type in ('R','Q','V')

Line 452: INDEX (asg PER_ASSIGNMENTS_F_PK) */

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,
456: act_run.tax_unit_id

Line 459: per_assignments_f asg

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
463: and ppa_run.action_type in ('R','Q','V')