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.

VIEW: APPS.PAY_GB_RTI_ASG_INFO_V

Source

View Text - Preformatted


SELECT aei.assignment_extra_info_id rti_asg_extra_info_id , aei.assignment_id assignment_id , aei.information_type INFORMATION_TYPE , aei.object_version_number RTI_OBJECT_VERSION_NUM , aei.aei_information_category AEI_INFORMATION_CATEGORY , aei.aei_information1 RTI_NEW_ST_DEC , aei.aei_information2 RTI_PREV_EMP_PAYE_REF , aei.aei_information3 RTI_PREV_TAX_CDE , aei.aei_information4 RTI_DT_LF_PREV_EMP , aei.aei_information5 RTI_PREV_TAX_BASIS , aei.aei_information6 RTI_LAST_PAY_PERIOD , aei.aei_information7 RTI_LAST_PAYMENT_PER_TYPE , aei.aei_information8 RTI_NS_RTI_SENT , aei.aei_information9 RTI_PEN_RTI_SENT , aei.aei_information10 RTI_STUDENT_LOAN , aei.aei_information11 RTI_NT_PAID_BET , aei.aei_information12 RTI_DT_PEN_START , aei.aei_information13 RTI_ANN_PEN_AMT , aei.aei_information14 RTI_REC_BER_FLG , aei.aei_information15 RT_EXPAT_ST , aei.aei_information16 RTI_DT_EMP_ST , aei.aei_information17 RTI_EEA_COMMON_CITIZEN , aei.aei_information18 RTI_EPM6_SCH , aei.aei_information19 RTI_EXPAT_RTI_SENT from per_assignment_extra_info aei where aei.information_type = 'GB_RTI_ASG_DETAILS'

View Text - HTML Formatted

SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID RTI_ASG_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID ASSIGNMENT_ID
, AEI.INFORMATION_TYPE INFORMATION_TYPE
, AEI.OBJECT_VERSION_NUMBER RTI_OBJECT_VERSION_NUM
, AEI.AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY
, AEI.AEI_INFORMATION1 RTI_NEW_ST_DEC
, AEI.AEI_INFORMATION2 RTI_PREV_EMP_PAYE_REF
, AEI.AEI_INFORMATION3 RTI_PREV_TAX_CDE
, AEI.AEI_INFORMATION4 RTI_DT_LF_PREV_EMP
, AEI.AEI_INFORMATION5 RTI_PREV_TAX_BASIS
, AEI.AEI_INFORMATION6 RTI_LAST_PAY_PERIOD
, AEI.AEI_INFORMATION7 RTI_LAST_PAYMENT_PER_TYPE
, AEI.AEI_INFORMATION8 RTI_NS_RTI_SENT
, AEI.AEI_INFORMATION9 RTI_PEN_RTI_SENT
, AEI.AEI_INFORMATION10 RTI_STUDENT_LOAN
, AEI.AEI_INFORMATION11 RTI_NT_PAID_BET
, AEI.AEI_INFORMATION12 RTI_DT_PEN_START
, AEI.AEI_INFORMATION13 RTI_ANN_PEN_AMT
, AEI.AEI_INFORMATION14 RTI_REC_BER_FLG
, AEI.AEI_INFORMATION15 RT_EXPAT_ST
, AEI.AEI_INFORMATION16 RTI_DT_EMP_ST
, AEI.AEI_INFORMATION17 RTI_EEA_COMMON_CITIZEN
, AEI.AEI_INFORMATION18 RTI_EPM6_SCH
, AEI.AEI_INFORMATION19 RTI_EXPAT_RTI_SENT
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI.INFORMATION_TYPE = 'GB_RTI_ASG_DETAILS'