HRT_PERSON_ASSIGNMENTS

Details

Name
PERSON_ID ASSIGNMENT_ID JOB_ID POSITION_ID BUSINESS_GROUP_ID BUSINESS_UNIT_ID ORGANIZATION_ID LOCATION_ID START_DATE ASSIGNMENT_TYPE GRADE_ID MANAGER_ID MANAGER_ASSIGNMENT_ID

Name

PERSON_ID

ASSIGNMENT_ID

JOB_ID

POSITION_ID

BUSINESS_GROUP_ID

BUSINESS_UNIT_ID

ORGANIZATION_ID

LOCATION_ID

START_DATE

ASSIGNMENT_TYPE

GRADE_ID

MANAGER_ID

MANAGER_ASSIGNMENT_ID

SQL_Statement
SELECT person.PERSON_ID, assign.ASSIGNMENT_ID, assign.JOB_ID, assign.POSITION_ID, person.BUSINESS_GROUP_ID, assign.BUSINESS_UNIT_ID, assign.ORGANIZATION_ID, assign.LOCATION_ID, person.START_DATE, assign.ASSIGNMENT_TYPE, assign.GRADE_ID, superv.MANAGER_ID, superv.MANAGER_ASSIGNMENT_ID FROM PER_PERSONS_V person, PER_ALL_ASSIGNMENTS_M_V assign, PER_ASSIGNMENT_SUPERVISORS_F_V superv WHERE assign.PERSON_ID = person.PERSON_ID AND assign.ASSIGNMENT_TYPE in ('E','C') AND assign.PRIMARY_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN assign.EFFECTIVE_START_DATE AND assign.EFFECTIVE_END_DATE AND assign.ASSIGNMENT_ID = superv.ASSIGNMENT_ID(+) AND superv.EFFECTIVE_START_DATE(+) BETWEEN assign.EFFECTIVE_START_DATE AND assign.EFFECTIVE_END_DATE AND superv.PRIMARY_FLAG(+) = 'Y'

SQL_Statement

SELECT person.PERSON_ID, assign.ASSIGNMENT_ID, assign.JOB_ID,

assign.POSITION_ID, person.BUSINESS_GROUP_ID,

assign.BUSINESS_UNIT_ID, assign.ORGANIZATION_ID,

assign.LOCATION_ID, person.START_DATE,

assign.ASSIGNMENT_TYPE, assign.GRADE_ID, superv.MANAGER_ID,

superv.MANAGER_ASSIGNMENT_ID FROM PER_PERSONS_V person,

PER_ALL_ASSIGNMENTS_M_V assign,

PER_ASSIGNMENT_SUPERVISORS_F_V superv WHERE assign.PERSON_ID

= person.PERSON_ID AND assign.ASSIGNMENT_TYPE in ('E','C')

AND assign.PRIMARY_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN

assign.EFFECTIVE_START_DATE AND assign.EFFECTIVE_END_DATE AND

assign.ASSIGNMENT_ID = superv.ASSIGNMENT_ID(+) AND

superv.EFFECTIVE_START_DATE(+) BETWEEN

assign.EFFECTIVE_START_DATE AND assign.EFFECTIVE_END_DATE AND

superv.PRIMARY_FLAG(+) = 'Y'