DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on PER_ALL_PEOPLE_F

Line 272: FROM per_all_people_f PE,

268: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
269: (PA.effective_date, AA.assignment_id)),
270: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
271: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
272: FROM per_all_people_f PE,
273: per_all_assignments_f SS,
274: pay_action_interlocks AI,
275: pay_assignment_actions AA,
276: pay_payroll_actions PA

Line 304: FROM per_all_people_f PE,

300: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
301: (PA.effective_date, AA.assignment_id)),
302: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
303: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
304: FROM per_all_people_f PE,
305: per_all_assignments_f SS,
306: pay_action_interlocks AI,
307: pay_assignment_actions AA,
308: pay_assignment_actions paa,

Line 352: FROM per_all_people_f PE,

348: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
349: (PA.effective_date, AA.assignment_id)),
350: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
351: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
352: FROM per_all_people_f PE,
353: per_all_assignments_f SS,
354: pay_action_interlocks AI,
355: pay_assignment_actions AA,
356: pay_payroll_actions PA

Line 441: FROM per_all_people_f PE,

437: (PA.effective_date, AA.assignment_id)),
438: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
439: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
440: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
441: FROM per_all_people_f PE,
442: per_all_assignments_f SS,
443: pay_action_interlocks AI,
444: pay_assignment_actions AA,
445: pay_payroll_actions PA