DBA Data[Home] [Help]

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PER_ALL_PEOPLE_F

Line 159: FROM per_all_people_f PE,

155: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
156: 'TRANSFER_OLD_ASG_ACTID=P', to_number(substr(AA.serial_number,16,15)), -- Originally Reported Assignment Action Id
157: 'TRANSFER_NEW_ASG_ACTID=P', to_number(substr(AA.serial_number,1,15)), -- Corrected Assignment Action Id
158: 'TRANSFER_TAX_UNIT_ID=P', AA.tax_unit_id
159: FROM per_all_people_f PE,
160: per_all_assignments_f SS,
161: pay_assignment_actions AA,
162: pay_payroll_actions PA
163: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value