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_PAYROLL_ACTIONS

Line 126: from pay_payroll_actions pact,

122: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
123: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
124: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
125: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
126: from pay_payroll_actions pact,
127: hr_organization_information hoi
128: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
129: and pact.business_group_id = hoi.organization_id
130: and hoi.org_information_context = 'Tax Details References'

Line 170: from pay_payroll_actions pay,

166: 'STUDENT_LOAN_FLAG_START_DATE=P', nvl(p453.action_information10,'X'),
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

Line 201: from pay_payroll_actions pact,

197: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
198: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
199: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
200: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
201: from pay_payroll_actions pact,
202: hr_organization_information hoi
203: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
204: and pact.business_group_id = hoi.organization_id
205: and hoi.org_information_context = 'Tax Details References'

Line 234: from pay_payroll_actions pay,

230: 'TITLE=P', nvl(substr(peo.action_information14,1,4),' '),
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

Line 265: from pay_payroll_actions pact,

261: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),
262: 'TAX_DISTRICT=P', upper(hoi.org_information2),
263: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
264: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
265: from pay_payroll_actions pact,
266: hr_organization_information hoi
267: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
268: and pact.business_group_id = hoi.organization_id
269: and hoi.org_information_context = 'Tax Details References'

Line 296: from pay_payroll_actions pay,

292: 'NATIONAL_INSURANCE_NUMBER=P', nvl(peo.action_information12,'NONE'),
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

Line 328: from pay_payroll_actions pact,

324: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
325: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
326: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
327: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
328: from pay_payroll_actions pact,
329: hr_organization_information hoi
330: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
331: and pact.business_group_id = hoi.organization_id
332: and hoi.org_information_context = 'Tax Details References'

Line 387: from pay_payroll_actions pact,

383: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
384: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
385: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
386: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
387: from pay_payroll_actions pact,
388: hr_organization_information hoi
389: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
390: and pact.business_group_id = hoi.organization_id
391: and hoi.org_information_context = 'Tax Details References'

Line 443: from pay_payroll_actions pay,

439: 'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(p453.action_information13,' '),
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

Line 483: from pay_payroll_actions pact,

479: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),
480: 'TAX_DISTRICT=P', upper(hoi.org_information2),
481: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
482: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
483: from pay_payroll_actions pact,
484: hr_organization_information hoi
485: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
486: and pact.business_group_id = hoi.organization_id
487: and hoi.org_information_context = 'Tax Details References'

Line 532: from pay_payroll_actions pay,

528: 'TAX_BASIS_PREV=P', nvl(p46p.action_information7,' '),
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

Line 564: from pay_payroll_actions pact,

560: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
561: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
562: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
563: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
564: from pay_payroll_actions pact,
565: hr_organization_information hoi
566: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
567: and pact.business_group_id = hoi.organization_id
568: and hoi.org_information_context = 'Tax Details References'

Line 600: from pay_payroll_actions pay,

596: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
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