eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ASSIGNMENT_ACTIONS

Line 193: pay_assignment_actions paa,

189: 'STUDENT_LOAN_FLAG_END_DATE=P', nvl(p453.action_information11,'4712/12/31 00:00:00'),
190: 'STUDENT_LOAN_FLAG_EFFECTIVE_END_DATE=P', nvl(p453.action_information12,'4712/12/31 00:00:00') ,
191: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
192: from pay_payroll_actions pay,
193: pay_assignment_actions paa,
194: pay_action_information addr,
195: pay_action_information peo,
196: pay_action_information p453
197: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 257: pay_assignment_actions paa,

253: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
254: 'SEX=P', nvl(peo.action_information17,' '),
255: 'JOB_TITLE=P', nvl(peo.action_information18,' ')
256: from pay_payroll_actions pay,
257: pay_assignment_actions paa,
258: pay_action_information addr,
259: pay_action_information peo,
260: pay_action_information p46
261: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 320: pay_assignment_actions paa,

316: 'POSTAL_CODE=P', nvl(addr.action_information12,' '),
317: 'TITLE=P', nvl(peo.action_information14,' '),
318: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' ')
319: from pay_payroll_actions pay,
320: pay_assignment_actions paa,
321: pay_action_information addr,
322: pay_action_information peo,
323: pay_action_information p46p
324: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 383: from pay_assignment_actions paa,

379: 'ASSIGNMENT_ID=P', paa.assignment_id,
380: 'ASSIGNMENT_NUMBER=P', nvl(upper(peo.action_information11), ' '), -- for MOVDED_ASG
381: 'NEW_ASSIGNMENT_NUMBER=P',nvl(upper(peo.action_information11), ' ') , -- for PAY_GB_EDI_WNU_3
382: 'OLD_ASSIGNMENT_NUMBER=P',nvl(upper(wnu3.action_information2), ' ') -- for PAY_GB_EDI_WNU_3
383: from pay_assignment_actions paa,
384: pay_action_information peo,
385: pay_action_information wnu3
386: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
387: and paa.assignment_action_id = peo.action_context_id

Line 468: pay_assignment_actions paa,

464: --'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(decode(p453.action_information13,0,' ',p453.action_information13),' '),
465: 'NOT_PAID_BETWEEN_START_AND5APR=P', decode(p453.action_information14,'Y','Y','N',' ',' '),
466: 'CONTINUE_SL_DEDUCTIONS=P', decode(p453.action_information15,'Y','Y','N',' ',' ')
467: from pay_payroll_actions pay,
468: pay_assignment_actions paa,
469: pay_action_information addr,
470: pay_action_information peo,
471: pay_action_information p453
472: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 558: pay_assignment_actions paa,

554: --'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(decode(p453.action_information13,0,' ',p453.action_information13),' '),
555: 'NOT_PAID_BETWEEN_START_AND5APR=P', decode(p453.action_information14,'Y','Y','N',' ',' '),
556: 'CONTINUE_SL_DEDUCTIONS=P', decode(p453.action_information15,'Y','Y','N',' ',' ')
557: from pay_payroll_actions pay,
558: pay_assignment_actions paa,
559: pay_action_information addr,
560: pay_action_information peo,
561: pay_action_information p453
562: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 648: pay_assignment_actions paa,

644: 'PREV_PAY_TYPE=P', nvl(p46p.action_information8,' '),
645: 'PREV_PAY_PERIOD=P', nvl(p46p.action_information9,' '),
646: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
647: from pay_payroll_actions pay,
648: pay_assignment_actions paa,
649: pay_action_information addr,
650: pay_action_information peo,
651: pay_action_information p46p
652: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 738: pay_assignment_actions paa,

734: 'PREV_PAY_TYPE=P', nvl(p46p.action_information8,' '),
735: 'PREV_PAY_PERIOD=P', nvl(p46p.action_information9,' '),
736: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
737: from pay_payroll_actions pay,
738: pay_assignment_actions paa,
739: pay_action_information addr,
740: pay_action_information peo,
741: pay_action_information p46p
742: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 808: pay_assignment_actions paa,

804: 'SEX=P', nvl(peo.action_information17,' '),
805: 'JOB_TITLE=P', nvl(peo.action_information18,' '),
806: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
807: from pay_payroll_actions pay,
808: pay_assignment_actions paa,
809: pay_action_information addr,
810: pay_action_information peo,
811: pay_action_information p46
812: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 879: pay_assignment_actions paa,

875: 'SEX=P', nvl(peo.action_information17,' '),
876: 'JOB_TITLE=P', nvl(peo.action_information18,' '),
877: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
878: from pay_payroll_actions pay,
879: pay_assignment_actions paa,
880: pay_action_information addr,
881: pay_action_information peo,
882: pay_action_information p46
883: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 953: pay_assignment_actions paa,

949: 'P46_EXPAT_START_EMPL_DATE=P', nvl(p46.action_information5,' '),
950: 'P46_EXPAT_EMP6_SCHEME=P', nvl(p46.action_information6,' ')
951:
952: from pay_payroll_actions pay,
953: pay_assignment_actions paa,
954: pay_action_information addr,
955: pay_action_information peo,
956: pay_action_information p46
957: where pay.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')