DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PAY_ASSIGNMENT_ACTIONS

Line 126: PAY_ASSIGNMENT_ACTIONS paa,

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
130: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value