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_ACTION_INFORMATION

Line 194: pay_action_information addr,

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')
198: and pay.payroll_action_id = paa.payroll_action_id

Line 195: pay_action_information peo,

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')
198: and pay.payroll_action_id = paa.payroll_action_id
199: and paa.assignment_action_id = peo.action_context_id

Line 196: pay_action_information p453

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')
198: and pay.payroll_action_id = paa.payroll_action_id
199: and paa.assignment_action_id = peo.action_context_id
200: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 258: pay_action_information addr,

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')
262: and pay.payroll_action_id = paa.payroll_action_id

Line 259: pay_action_information peo,

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')
262: and pay.payroll_action_id = paa.payroll_action_id
263: and paa.assignment_action_id = peo.action_context_id

Line 260: pay_action_information p46

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')
262: and pay.payroll_action_id = paa.payroll_action_id
263: and paa.assignment_action_id = peo.action_context_id
264: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 321: pay_action_information addr,

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')
325: and pay.payroll_action_id = paa.payroll_action_id

Line 322: pay_action_information peo,

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')
325: and pay.payroll_action_id = paa.payroll_action_id
326: and paa.assignment_action_id = peo.action_context_id

Line 323: pay_action_information p46p

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')
325: and pay.payroll_action_id = paa.payroll_action_id
326: and paa.assignment_action_id = peo.action_context_id
327: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 384: pay_action_information peo,

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
388: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 385: pay_action_information wnu3

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
388: and peo.action_information_category = 'GB EMPLOYEE DETAILS'
389: and peo.action_context_type = 'AAP'

Line 469: pay_action_information addr,

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')
473: and pay.payroll_action_id = paa.payroll_action_id

Line 470: pay_action_information peo,

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')
473: and pay.payroll_action_id = paa.payroll_action_id
474: and paa.assignment_action_id = peo.action_context_id

Line 471: pay_action_information p453

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')
473: and pay.payroll_action_id = paa.payroll_action_id
474: and paa.assignment_action_id = peo.action_context_id
475: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 559: pay_action_information addr,

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')
563: and pay.payroll_action_id = paa.payroll_action_id

Line 560: pay_action_information peo,

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')
563: and pay.payroll_action_id = paa.payroll_action_id
564: and paa.assignment_action_id = peo.action_context_id

Line 561: pay_action_information p453

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')
563: and pay.payroll_action_id = paa.payroll_action_id
564: and paa.assignment_action_id = peo.action_context_id
565: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 649: pay_action_information addr,

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')
653: and pay.payroll_action_id = paa.payroll_action_id

Line 650: pay_action_information peo,

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')
653: and pay.payroll_action_id = paa.payroll_action_id
654: and paa.assignment_action_id = peo.action_context_id

Line 651: pay_action_information p46p

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')
653: and pay.payroll_action_id = paa.payroll_action_id
654: and paa.assignment_action_id = peo.action_context_id
655: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 739: pay_action_information addr,

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')
743: and pay.payroll_action_id = paa.payroll_action_id

Line 740: pay_action_information peo,

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')
743: and pay.payroll_action_id = paa.payroll_action_id
744: and paa.assignment_action_id = peo.action_context_id

Line 741: pay_action_information p46p

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')
743: and pay.payroll_action_id = paa.payroll_action_id
744: and paa.assignment_action_id = peo.action_context_id
745: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 809: pay_action_information addr,

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')
813: and pay.payroll_action_id = paa.payroll_action_id

Line 810: pay_action_information peo,

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')
813: and pay.payroll_action_id = paa.payroll_action_id
814: and paa.assignment_action_id = peo.action_context_id

Line 811: pay_action_information p46

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')
813: and pay.payroll_action_id = paa.payroll_action_id
814: and paa.assignment_action_id = peo.action_context_id
815: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 880: pay_action_information addr,

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')
884: and pay.payroll_action_id = paa.payroll_action_id

Line 881: pay_action_information peo,

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')
884: and pay.payroll_action_id = paa.payroll_action_id
885: and paa.assignment_action_id = peo.action_context_id

Line 882: pay_action_information p46

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')
884: and pay.payroll_action_id = paa.payroll_action_id
885: and paa.assignment_action_id = peo.action_context_id
886: and peo.action_information_category = 'GB EMPLOYEE DETAILS'

Line 954: pay_action_information addr,

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')
958: and pay.payroll_action_id = paa.payroll_action_id

Line 955: pay_action_information peo,

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')
958: and pay.payroll_action_id = paa.payroll_action_id
959: and paa.assignment_action_id = peo.action_context_id

Line 956: pay_action_information p46

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')
958: and pay.payroll_action_id = paa.payroll_action_id
959: and paa.assignment_action_id = peo.action_context_id
960: and peo.action_information_category = 'GB EMPLOYEE DETAILS'