DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on PER_ALL_PEOPLE_F

Line 296: per_all_people_f PE

292: FROM pay_payroll_actions PA,
293: pay_assignment_actions AA,
294: pay_action_interlocks AI,
295: per_all_assignments_f SS,
296: per_all_people_f PE
297: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')
299: AND AA.payroll_action_id = PA.payroll_action_id
300: AND AA.tax_unit_id = pay_magtape_generic.get_parameter_value

Line 325: FROM per_all_people_f PE,

321: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
322: (PA.effective_date, AA.assignment_id)),
323: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
324: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
325: FROM per_all_people_f PE,
326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,

Line 373: FROM per_all_people_f PE,

369: 'DATE_EARNED=C', fnd_date.date_to_canonical(pay_magtape_generic.date_earned
370: (PA.effective_date, AA.assignment_id)),
371: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
372: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
373: FROM per_all_people_f PE,
374: per_all_assignments_f SS,
375: pay_action_interlocks AI,
376: pay_assignment_actions AA,
377: pay_payroll_actions PA