VIEW: APPS.PSP_PAYROLL_INTERFACE_V

Source

View Text - Preformatted

SELECT A.PAYROLL_ID , A.PAYROLL_INTERFACE_ID INTERFACE_ID , PSP_GENERAL.GET_PAYROLL_NAME(A.PAYROLL_ID, A.EFFECTIVE_DATE) PAYROLL_NAME , A.PAYROLL_PERIOD_ID , PSP_GENERAL.GET_PERIOD_NAME(A.PAYROLL_PERIOD_ID) PAYROLL_PERIOD_NAME , A.PERSON_ID , PSP_GENERAL.GET_PERSON_NAME(A.PERSON_ID, A.EFFECTIVE_DATE) PERSON , A.ASSIGNMENT_ID , PSP_GENERAL.GET_ASSIGNMENT_NUM(A.ASSIGNMENT_ID, A.EFFECTIVE_DATE) ASSIGNMENT_NUMBER , A.ELEMENT_TYPE_ID , A.PAY_AMOUNT , A.EARNED_DATE , A.CHECK_DATE , A.EFFECTIVE_DATE , A.FTE , A.PAYROLL_SOURCE_CODE , A.REASON_CODE , A.DAILY_RATE , A.SALARY_USED , A.SUB_LINE_START_DATE , A.SUB_LINE_END_DATE , A.STATUS_CODE , A.BATCH_NAME , A.ERROR_CODE , A.DR_CR_FLAG , PSP_GENERAL.GET_ELEMENT_NAME(A.ELEMENT_TYPE_ID, A.EFFECTIVE_DATE) ELEMENT_NAME , PSP_GENERAL.GET_SOURCE_TYPE('N', A.PAYROLL_SOURCE_CODE) SOURCE_TYPE , PSP_GENERAL.GET_STATUS_DESCRIPTION(A.STATUS_CODE) STATUS_DESCRIPTION , DECODE(A.STATUS_CODE, 'E', PSP_GENERAL.GET_ERROR_DESCRIPTION(A.ERROR_CODE), NULL) ERROR_DESCRIPTION , A.GL_POSTING_OVERRIDE_DATE , A.GMS_POSTING_OVERRIDE_DATE ,A.BUSINESS_GROUP_ID ,A.SET_OF_BOOKS_ID ,A.ATTRIBUTE_CATEGORY ,A.ATTRIBUTE1 , A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4 , A.ATTRIBUTE5 , A.ATTRIBUTE6 , A.ATTRIBUTE7 , A.ATTRIBUTE8 , A.ATTRIBUTE9 , A.ATTRIBUTE10 , A.ATTRIBUTE11 , A.ATTRIBUTE12 , A.ATTRIBUTE13 , A.ATTRIBUTE14 , A.ATTRIBUTE15 FROM PSP_PAYROLL_INTERFACE A

View Text - HTML Formatted

SELECT A.PAYROLL_ID
, A.PAYROLL_INTERFACE_ID INTERFACE_ID
, PSP_GENERAL.GET_PAYROLL_NAME(A.PAYROLL_ID
, A.EFFECTIVE_DATE) PAYROLL_NAME
, A.PAYROLL_PERIOD_ID
, PSP_GENERAL.GET_PERIOD_NAME(A.PAYROLL_PERIOD_ID) PAYROLL_PERIOD_NAME
, A.PERSON_ID
, PSP_GENERAL.GET_PERSON_NAME(A.PERSON_ID
, A.EFFECTIVE_DATE) PERSON
, A.ASSIGNMENT_ID
, PSP_GENERAL.GET_ASSIGNMENT_NUM(A.ASSIGNMENT_ID
, A.EFFECTIVE_DATE) ASSIGNMENT_NUMBER
, A.ELEMENT_TYPE_ID
, A.PAY_AMOUNT
, A.EARNED_DATE
, A.CHECK_DATE
, A.EFFECTIVE_DATE
, A.FTE
, A.PAYROLL_SOURCE_CODE
, A.REASON_CODE
, A.DAILY_RATE
, A.SALARY_USED
, A.SUB_LINE_START_DATE
, A.SUB_LINE_END_DATE
, A.STATUS_CODE
, A.BATCH_NAME
, A.ERROR_CODE
, A.DR_CR_FLAG
, PSP_GENERAL.GET_ELEMENT_NAME(A.ELEMENT_TYPE_ID
, A.EFFECTIVE_DATE) ELEMENT_NAME
, PSP_GENERAL.GET_SOURCE_TYPE('N'
, A.PAYROLL_SOURCE_CODE) SOURCE_TYPE
, PSP_GENERAL.GET_STATUS_DESCRIPTION(A.STATUS_CODE) STATUS_DESCRIPTION
, DECODE(A.STATUS_CODE
, 'E'
, PSP_GENERAL.GET_ERROR_DESCRIPTION(A.ERROR_CODE)
, NULL) ERROR_DESCRIPTION
, A.GL_POSTING_OVERRIDE_DATE
, A.GMS_POSTING_OVERRIDE_DATE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM PSP_PAYROLL_INTERFACE A