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 148: from pay_payroll_actions pact,

144: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
145: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
146: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
147: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
148: from pay_payroll_actions pact,
149: hr_organization_information hoi
150: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
151: and pact.business_group_id = hoi.organization_id
152: and hoi.org_information_context = 'Tax Details References'

Line 192: from pay_payroll_actions pay,

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

Line 223: from pay_payroll_actions pact,

219: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
220: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
221: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
222: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
223: from pay_payroll_actions pact,
224: hr_organization_information hoi
225: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
226: and pact.business_group_id = hoi.organization_id
227: and hoi.org_information_context = 'Tax Details References'

Line 256: from pay_payroll_actions pay,

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

Line 287: from pay_payroll_actions pact,

283: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),
284: 'TAX_DISTRICT=P', upper(hoi.org_information2),
285: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
286: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
287: from pay_payroll_actions pact,
288: hr_organization_information hoi
289: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
290: and pact.business_group_id = hoi.organization_id
291: and hoi.org_information_context = 'Tax Details References'

Line 319: from pay_payroll_actions pay,

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

Line 351: from pay_payroll_actions pact,

347: 'TAX_DIST_REF=P', nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' '),
348: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
349: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
350: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' ')
351: from pay_payroll_actions pact,
352: hr_organization_information hoi
353: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
354: and pact.business_group_id = hoi.organization_id
355: and hoi.org_information_context = 'Tax Details References'

Line 410: from pay_payroll_actions pact,

406: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
407: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
408: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
409: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
410: from pay_payroll_actions pact,
411: hr_organization_information hoi
412: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
413: and pact.business_group_id = hoi.organization_id
414: and hoi.org_information_context = 'Tax Details References'

Line 467: from pay_payroll_actions pay,

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

Line 501: from pay_payroll_actions pact,

497: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
498: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
499: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
500: 'TEST_ID=P', nvl(pay_magtape_generic.get_parameter_value('TEST_ID'),' ') /*added for P45PT_3*/
501: from pay_payroll_actions pact,
502: hr_organization_information hoi
503: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
504: and pact.business_group_id = hoi.organization_id
505: and hoi.org_information_context = 'Tax Details References'

Line 557: from pay_payroll_actions pay,

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

Line 597: from pay_payroll_actions pact,

593: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),
594: 'TAX_DISTRICT=P', upper(hoi.org_information2),
595: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
596: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
597: from pay_payroll_actions pact,
598: hr_organization_information hoi
599: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
600: and pact.business_group_id = hoi.organization_id
601: and hoi.org_information_context = 'Tax Details References'

Line 647: from pay_payroll_actions pay,

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

Line 685: from pay_payroll_actions pact,

681: 'TAX_DIST_REF=P', upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),
682: 'TAX_DISTRICT=P', upper(hoi.org_information2),
683: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
684: 'EMPLOYERS_NAME=P',nvl(upper(hoi.org_information3),' ')
685: from pay_payroll_actions pact,
686: hr_organization_information hoi
687: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
688: and pact.business_group_id = hoi.organization_id
689: and hoi.org_information_context = 'Tax Details References'

Line 737: from pay_payroll_actions pay,

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

Line 770: from pay_payroll_actions pact,

766: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
767: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
768: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
769: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
770: from pay_payroll_actions pact,
771: hr_organization_information hoi
772: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
773: and pact.business_group_id = hoi.organization_id
774: and hoi.org_information_context = 'Tax Details References'

Line 807: from pay_payroll_actions pay,

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

Line 841: from pay_payroll_actions pact,

837: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
838: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
839: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
840: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
841: from pay_payroll_actions pact,
842: hr_organization_information hoi
843: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
844: and pact.business_group_id = hoi.organization_id
845: and hoi.org_information_context = 'Tax Details References'

Line 878: from pay_payroll_actions pay,

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

Line 913: from pay_payroll_actions pact,

909: 'TAX_DISTRICT=P', nvl(upper(hoi.org_information2),' '),
910: 'EMPLOYERS_ADDRESS_LINE=P', nvl(upper(hoi.org_information4),' '),
911: 'EMPLOYERS_NAME=P', nvl(upper(hoi.org_information3),' '),
912: 'TEST_ID=P', pay_magtape_generic.get_parameter_value('TEST_ID')
913: from pay_payroll_actions pact,
914: hr_organization_information hoi
915: where pact.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
916: and pact.business_group_id = hoi.organization_id
917: and hoi.org_information_context = 'Tax Details References'

Line 952: from pay_payroll_actions pay,

948: 'P46_EXPAT_EEA_CITIZEN=P', nvl(p46.action_information4,' '),
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