DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PAY_PAYROLL_ACTIONS

Line 125: from PAY_PAYROLL_ACTIONS ppa,

121: 'ASSIGNMENT_ID=C', paa.assignment_id,
122: 'TRANSFER_WAGES_EARNED=P', ltrim(substr(paa.serial_number,1,20)),
123: 'TRANSFER_ASG_START_DATE=P',to_char(paf.effective_start_date,'DD-MM-YYYY'),
124: 'TRANSFER_ASG_END_DATE=P', to_char(paf.effective_end_date,'DD-MM-YYYY')
125: from PAY_PAYROLL_ACTIONS ppa,
126: PAY_ASSIGNMENT_ACTIONS paa,
127: PER_ASSIGNMENTS_F paf,
128: PER_PEOPLE_F ppf,
129: HR_SOFT_CODING_KEYFLEX scl