View: PSP_PAYROLL_INTERFACE_V

Product:	PSP - Labor Distribution
Description:	Based on the PSP_PAYROLL_INTERFACE table------View modified on 14-NOV-2001 by Ritesh to fix Bug:2103460. Group By clause, Several where clauses and tables (per_people_f, per_assignments_f, pay_payrolls_f) have been removed form the query.
Implementation/DBA Data:	APPS.PSP_PAYROLL_INTERFACE_V

View Text

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

Columns