View: BEN_ASSIGNMENT_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ASSIGNMENT_D

View Text

SELECT ASSIGN.ASSIGNMENT_ID
, ASSIGN.EFFECTIVE_START_DATE
, ASSIGN.EFFECTIVE_END_DATE
, LOC.LOCATION_CODE
, ORGTL.NAME
, GRP.GROUP_NAME
, JOB.NAME
, POS.NAME
, GRADE.NAME
, PAYROLL.PAYROLL_NAME
, HR3.MEANING
, ASSIGN.NORMAL_HOURS
, HR1.MEANING
, HR2.MEANING
, ASSIGN.TIME_NORMAL_START
, ASSIGN.TIME_NORMAL_FINISH
, HR4.MEANING
, ASSIGN.LABOUR_UNION_MEMBER_FLAG
, BASIS.NAME
, ASSIGN.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PER_ASSIGNMENTS_F ASSIGN
, PER_ALL_PEOPLE_F REC
, PER_GRADES_VL GRADE
, PER_POSITIONS POS
, PER_JOBS_VL JOB
, PAY_ALL_PAYROLLS_F PAYROLL
, HR_LOCATIONS LOC
, HR_ALL_ORGANIZATION_UNITS_VL ORGTL
, PAY_PEOPLE_GROUPS GRP
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, FND_USER FUSER
, PER_PAY_BASES BASIS
WHERE GRADE.GRADE_ID (+)= ASSIGN.GRADE_ID
AND REC.PERSON_ID = ASSIGN.PERSON_ID
AND ASSIGN.EFFECTIVE_START_DATE BETWEEN NVL (REC.EFFECTIVE_START_DATE
, ASSIGN.EFFECTIVE_START_DATE)
AND NVL (REC.EFFECTIVE_END_DATE
, ASSIGN.EFFECTIVE_START_DATE)
AND POS.POSITION_ID (+)= ASSIGN.POSITION_ID
AND JOB.JOB_ID (+)= ASSIGN.JOB_ID
AND PAYROLL.PAYROLL_ID (+)= ASSIGN.PAYROLL_ID
AND ASSIGN.EFFECTIVE_START_DATE BETWEEN NVL (PAYROLL.EFFECTIVE_START_DATE
, ASSIGN.EFFECTIVE_START_DATE)
AND NVL (PAYROLL.EFFECTIVE_END_DATE
, ASSIGN.EFFECTIVE_START_DATE)
AND LOC.LOCATION_ID (+)= ASSIGN.LOCATION_ID
AND ORGTL.ORGANIZATION_ID = ASSIGN.ORGANIZATION_ID
AND GRP.PEOPLE_GROUP_ID (+)= ASSIGN.PEOPLE_GROUP_ID
AND HR1.LOOKUP_CODE (+)= ASSIGN.FREQUENCY
AND HR1.LOOKUP_TYPE (+)= 'FREQUENCY'
AND HR2.LOOKUP_CODE (+)= ASSIGN.HOURLY_SALARIED_CODE
AND HR2.LOOKUP_TYPE (+)= 'HOURLY_SALARIED_CODE'
AND HR3.LOOKUP_CODE (+)= ASSIGN.EMPLOYMENT_CATEGORY
AND HR3.LOOKUP_TYPE (+)= 'EMP_CAT'
AND HR4.LOOKUP_CODE (+)= ASSIGN.BARGAINING_UNIT_CODE
AND HR4.LOOKUP_TYPE(+)= 'BARGAINING_UNIT_CODE'
AND BASIS.PAY_BASIS_ID (+)= ASSIGN.PAY_BASIS_ID
AND FUSER.USER_ID (+)= ASSIGN.LAST_UPDATED_BY

Columns