VIEW: APPS.BEN_ASSIGNMENT_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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