VIEW: APPS.GHR_SF113_V

Source

View Text - Preformatted

SELECT DISTINCT PPF.PERSON_ID , DECODE(PAST.PER_SYSTEM_STATUS,'ACTIVE_ASSIGN','1','TERM_ASSIGN',2, 0) STATUS , PA.EFFECTIVE_START_DATE , PA.EFFECTIVE_END_DATE , PA.ASSIGNMENT_ID , PA.POSITION_ID , PA.GRADE_ID , PA.LOCATION_ID FROM PER_ASSIGNMENTS_F PA , PER_ASSIGNMENT_STATUS_TYPES PAST , PER_PEOPLE_F PPF , PER_GRADES PG , PER_GRADE_DEFINITIONS PGD WHERE (PAST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN','TERM_ASSIGN')) AND (PA.ASSIGNMENT_TYPE <> 'B') AND SUBSTR(PGD.SEGMENT1,1,2) NOT IN ('CC','NA','NL','NS') AND PA.PRIMARY_FLAG = 'Y' AND PA.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID AND (PA.GRADE_ID = PG.GRADE_ID) AND (PG.GRADE_DEFINITION_ID = PGD.GRADE_DEFINITION_ID) AND (PPF.PERSON_ID = PA.PERSON_ID)

View Text - HTML Formatted

SELECT DISTINCT PPF.PERSON_ID
, DECODE(PAST.PER_SYSTEM_STATUS
, 'ACTIVE_ASSIGN'
, '1'
, 'TERM_ASSIGN'
, 2
, 0) STATUS
, PA.EFFECTIVE_START_DATE
, PA.EFFECTIVE_END_DATE
, PA.ASSIGNMENT_ID
, PA.POSITION_ID
, PA.GRADE_ID
, PA.LOCATION_ID
FROM PER_ASSIGNMENTS_F PA
, PER_ASSIGNMENT_STATUS_TYPES PAST
, PER_PEOPLE_F PPF
, PER_GRADES PG
, PER_GRADE_DEFINITIONS PGD
WHERE (PAST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'TERM_ASSIGN'))
AND (PA.ASSIGNMENT_TYPE <> 'B')
AND SUBSTR(PGD.SEGMENT1
, 1
, 2) NOT IN ('CC'
, 'NA'
, 'NL'
, 'NS')
AND PA.PRIMARY_FLAG = 'Y'
AND PA.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
AND (PA.GRADE_ID = PG.GRADE_ID)
AND (PG.GRADE_DEFINITION_ID = PGD.GRADE_DEFINITION_ID)
AND (PPF.PERSON_ID = PA.PERSON_ID)