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 172: pay_action_information addr,

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

Line 173: pay_action_information peo,

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

Line 174: pay_action_information p453

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

Line 236: pay_action_information addr,

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

Line 237: pay_action_information peo,

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

Line 238: pay_action_information p46

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

Line 298: pay_action_information addr,

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

Line 299: pay_action_information peo,

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

Line 300: pay_action_information p46p

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

Line 361: pay_action_information peo,

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

Line 362: pay_action_information wnu3

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

Line 445: pay_action_information addr,

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

Line 446: pay_action_information peo,

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

Line 447: pay_action_information p453

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

Line 534: pay_action_information addr,

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

Line 535: pay_action_information peo,

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

Line 536: pay_action_information p46p

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

Line 602: pay_action_information addr,

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

Line 603: pay_action_information peo,

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

Line 604: pay_action_information p46

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