DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on PER_ALL_PEOPLE_F

Line 273: FROM per_all_people_f PE,

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

Line 305: FROM per_all_people_f PE,

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

Line 353: FROM per_all_people_f PE,

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

Line 442: FROM per_all_people_f PE,

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