APPS.PAY_US_MAGW2_REPORTING dependencies on PER_PEOPLE_F

Line 170: FROM per_people_f PE,

166: SELECT 'ASSIGNMENT_ACTION_ID=C', AI.locked_action_id, -- YREND assignment action
167: 'ASSIGNMENT_ID=C', AA.assignment_id,
168: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
169: (PA.effective_date, AA.assignment_id))
170: FROM per_people_f PE,
171: per_assignments_f SS,
172: pay_action_interlocks AI,
173: pay_assignment_actions AA,
174: pay_payroll_actions PA

Line 232: FROM per_people_f PE,

228: 'ASSIGNMENT_ID=C', AA.assignment_id,
229: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
230: (PA.effective_date, AA.assignment_id)),
231: 'JURISDICTION_CODE=C', SR.jurisdiction_code
232: FROM per_people_f PE,
233: per_assignments_f SS,
234: pay_state_rules SR,
235: pay_action_interlocks AI,
236: pay_assignment_actions AA,

Line 266: FROM per_people_f PE,

262: 'YREND_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
263: 'YREND_ASSIGNMENT_ID=P',AA.assignment_id,
264: 'DATE_EARNED=P', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
265: (PA.effective_date, AA.assignment_id))
266: FROM per_people_f PE,
267: per_assignments_f SS,
268: pay_action_interlocks AI,
269: pay_assignment_actions AA,
270: pay_payroll_actions PA

Line 435: FROM per_people_f ppf,

431:
432: CURSOR w2_high_comp IS
433: SELECT 'TRANSFER_MESSAGE=P',
434: tuv.name || '-' || ppf.full_name||'('||ppf.employee_number||')'||fnd_global.local_chr(10)
435: FROM per_people_f ppf,
436: per_assignments_f paf,
437: pay_assignment_actions paa,
438: hr_tax_units_v tuv,
439: pay_payroll_actions ppa