View: PQP_ASSIGNMENT_ATTRIBUTES_D

Product:	PQP - Public Sector Payroll
Description:	View for DateTrack history of the table PQP_ASSIGNMENT_ATTRIBUTES_F
Implementation/DBA Data:	APPS.PQP_ASSIGNMENT_ATTRIBUTES_D

View Text

SELECT AAT.ASSIGNMENT_ATTRIBUTE_ID
, AAT.EFFECTIVE_START_DATE
, AAT.EFFECTIVE_END_DATE
, AAT.CONTRACT_TYPE
, AAT.WORK_PATTERN
, AAT.START_DAY
, HRL1.MEANING
, AAT.TP_SAFEGUARDED_GRADE
, AAT.TP_SAFEGUARDED_RATE_TYPE
, PR.NAME TP_SAFEGUARDED_RATE_NAME
, PSP.SPINAL_POINT TP_SAFEGUARDED_SPINAL_POINT
, AAT.TP_ELECTED_PENSION
, AAT.TP_FAST_TRACK
, AAT.TP_HEADTEACHER_GRP_CODE
, AAT.LAST_UPDATE_DATE
, USR.USER_NAME LAST_UPDATED_BY
, AAT.LGPS_PROCESS_FLAG
, AAT.LGPS_EXCLUSION_TYPE
, AAT.LGPS_PENSIONABLE_PAY
, AAT.LGPS_TRANS_ARRANG_FLAG
, AAT.LGPS_MEMBERSHIP_NUMBER
FROM PQP_ASSIGNMENT_ATTRIBUTES_F AAT
, PQP_VEHICLE_DETAILS PVD1
, PQP_VEHICLE_DETAILS PVD2
, PQP_VEHICLE_DETAILS PVD3
, PAY_USER_TABLES UDT1
, PAY_USER_TABLES UDT2
, PAY_USER_TABLES UDT3
, PAY_USER_TABLES UDT4
, FND_USER_VIEW USR
, HR_LOOKUPS HRL1
, PAY_RATES PR
, PER_SPINAL_POINTS PSP
WHERE USR.USER_ID (+) = AAT.LAST_UPDATED_BY
AND AAT.PRIMARY_COMPANY_CAR = PVD1.VEHICLE_DETAILS_ID(+)
AND AAT.SECONDARY_COMPANY_CAR = PVD2.VEHICLE_DETAILS_ID(+)
AND AAT.PRIVATE_CAR = PVD3.VEHICLE_DETAILS_ID(+)
AND AAT.COMPANY_CAR_RATES_TABLE_ID = UDT1.USER_TABLE_ID(+)
AND AAT.COMPANY_CAR_SECONDARY_TABLE_ID = UDT2.USER_TABLE_ID(+)
AND AAT.PRIVATE_CAR_RATES_TABLE_ID = UDT3.USER_TABLE_ID(+)
AND AAT.PRIVATE_CAR_ESSENTIAL_TABLE_ID = UDT4.USER_TABLE_ID(+)
AND AAT.TP_IS_TEACHER = HRL1.LOOKUP_CODE(+)
AND HRL1.LOOKUP_TYPE(+) = 'PQP_GB_TEACHER_JOB_STATUS'
AND AAT.TP_SAFEGUARDED_RATE_ID=PR.RATE_ID(+)
AND AAT.TP_SAFEGUARDED_SPINAL_POINT_ID=PSP.SPINAL_POINT_ID(+)

Columns