DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING1 dependencies on PER_ALL_PEOPLE_F

Line 310: FROM per_all_people_f PE,

306: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
307: (PA.effective_date, AA.assignment_id)),
308: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
309: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
310: FROM per_all_people_f PE,
311: per_all_assignments_f SS,
312: pay_action_interlocks AI,
313: pay_assignment_actions AA,
314: pay_payroll_actions PA

Line 343: FROM per_all_people_f PE,

339: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
340: (PA.effective_date, AA.assignment_id)),
341: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
342: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
343: FROM per_all_people_f PE,
344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,

Line 391: FROM per_all_people_f PE,

387: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
388: (PA.effective_date, AA.assignment_id)),
389: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
390: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
391: FROM per_all_people_f PE,
392: per_all_assignments_f SS,
393: pay_action_interlocks AI,
394: pay_assignment_actions AA,
395: pay_payroll_actions PA

Line 480: FROM per_all_people_f PE,

476: (PA.effective_date, AA.assignment_id)),
477: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
478: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
479: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
480: FROM per_all_people_f PE,
481: per_all_assignments_f SS,
482: pay_action_interlocks AI,
483: pay_assignment_actions AA,
484: pay_payroll_actions PA