[Home] [Help]
167: 'STUDENT_LOAN_FLAG_END_DATE=P', nvl(p453.action_information11,'4712/12/31 00:00:00'),
168: 'STUDENT_LOAN_FLAG_EFFECTIVE_END_DATE=P', nvl(p453.action_information12,'4712/12/31 00:00:00') ,
169: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
170: from pay_payroll_actions pay,
171: pay_assignment_actions paa,
172: pay_action_information addr,
173: pay_action_information peo,
174: pay_action_information p453
175: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
231: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
232: 'SEX=P', nvl(peo.action_information17,' '),
233: 'JOB_TITLE=P', nvl(peo.action_information18,' ')
234: from pay_payroll_actions pay,
235: pay_assignment_actions paa,
236: pay_action_information addr,
237: pay_action_information peo,
238: pay_action_information p46
239: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
293: 'POSTAL_CODE=P', nvl(addr.action_information12,' '),
294: 'TITLE=P', nvl(peo.action_information14,' '),
295: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' ')
296: from pay_payroll_actions pay,
297: pay_assignment_actions paa,
298: pay_action_information addr,
299: pay_action_information peo,
300: pay_action_information p46p
301: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
356: 'ASSIGNMENT_ID=P', paa.assignment_id,
357: 'ASSIGNMENT_NUMBER=P', nvl(upper(peo.action_information11), ' '), -- for MOVDED_ASG
358: 'NEW_ASSIGNMENT_NUMBER=P',nvl(upper(peo.action_information11), ' ') , -- for PAY_GB_EDI_WNU_3
359: 'OLD_ASSIGNMENT_NUMBER=P',nvl(upper(wnu3.action_information2), ' ') -- for PAY_GB_EDI_WNU_3
360: from pay_assignment_actions paa,
361: pay_action_information peo,
362: pay_action_information wnu3
363: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
364: and paa.assignment_action_id = peo.action_context_id
440: --'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(decode(p453.action_information13,0,' ',p453.action_information13),' '),
441: 'NOT_PAID_BETWEEN_START_AND5APR=P', decode(p453.action_information14,'Y','Y','N',' ',' '),
442: 'CONTINUE_SL_DEDUCTIONS=P', decode(p453.action_information15,'Y','Y','N',' ',' ')
443: from pay_payroll_actions pay,
444: pay_assignment_actions paa,
445: pay_action_information addr,
446: pay_action_information peo,
447: pay_action_information p453
448: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
529: 'PREV_PAY_TYPE=P', nvl(p46p.action_information8,' '),
530: 'PREV_PAY_PERIOD=P', nvl(p46p.action_information9,' '),
531: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
532: from pay_payroll_actions pay,
533: pay_assignment_actions paa,
534: pay_action_information addr,
535: pay_action_information peo,
536: pay_action_information p46p
537: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
597: 'SEX=P', nvl(peo.action_information17,' '),
598: 'JOB_TITLE=P', nvl(peo.action_information18,' '),
599: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
600: from pay_payroll_actions pay,
601: pay_assignment_actions paa,
602: pay_action_information addr,
603: pay_action_information peo,
604: pay_action_information p46
605: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')