DBA Data[Home] [Help]

APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 162: per_all_assignments_f SS,

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