DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PER_ALL_PEOPLE_F

Line 286: per_all_people_f PE

282: FROM pay_payroll_actions PA,
283: pay_assignment_actions AA,
284: pay_action_interlocks AI,
285: per_all_assignments_f SS,
286: per_all_people_f PE
287: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
288: ('TRANSFER_PAYROLL_ACTION_ID')
289: AND AA.payroll_action_id = PA.payroll_action_id
290: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 315: FROM per_all_people_f PE,

311: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
312: (PA.effective_date, AA.assignment_id)),
313: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
314: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
315: FROM per_all_people_f PE,
316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,

Line 363: FROM per_all_people_f PE,

359: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
360: (PA.effective_date, AA.assignment_id)),
361: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
362: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
363: FROM per_all_people_f PE,
364: per_all_assignments_f SS,
365: pay_action_interlocks AI,
366: pay_assignment_actions AA,
367: pay_payroll_actions PA