View: IGF_GR_PERSON_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_GR_PERSON_V

View Text

SELECT FA.ROW_ID
, FA.BASE_ID
, FA.PERSON_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PARTY_NAME PERSON_NAME
, P.PERSON_LAST_NAME SURNAME
, P.PERSON_FIRST_NAME GIVEN_NAMES
, P.PERSON_MIDDLE_NAME MIDDLE_NAME
, PP.DATE_OF_BIRTH BIRTH_DT
, FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, API.API_PERSON_ID API_PERSON_ID
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGF_AP_FA_BASE_REC FA
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PIT
WHERE FA.PERSON_ID = P.PARTY_ID
AND FA.PERSON_ID = PP.PARTY_ID (+)
AND FA.PERSON_ID = API.PE_PERSON_ID(+)
AND ( SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE))
AND ( SYSDATE BETWEEN NVL(API.START_DT
, SYSDATE)
AND NVL(API.END_DT
, SYSDATE))
AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE
AND PIT.S_PERSON_ID_TYPE = 'SSN'

Columns