[Home] [Help]
View: IGF_AP_FA_BASE_RESULTS_V
Product: | IGF - Financial Aid |
Description: | Shows all the award years available from the calendar setup |
Implementation/DBA Data: |
APPS.IGF_AP_FA_BASE_RESULTS_V
|
View Text
SELECT FA.PERSON_ID
, FA.BASE_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, PE.PERSON_LAST_NAME||'
, '||PE.PERSON_FIRST_NAME
, PIT.API_PERSON_ID
, HPP.DATE_OF_BIRTH
, FA.CI_CAL_TYPE CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
FROM IGF_AP_FA_BASE_REC FA
, HZ_PARTIES PE
, HZ_PERSON_PROFILES HPP
, IGS_CA_INST CA
, ( SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE) ) PIT
WHERE PE.PARTY_ID = HPP.PARTY_ID
AND SYSDATE BETWEEN HPP.EFFECTIVE_START_DATE
AND NVL(HPP.EFFECTIVE_END_DATE
, SYSDATE)
AND FA.CI_CAL_TYPE = CA.CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND FA.PERSON_ID = PE.PARTY_ID
AND PE.PARTY_ID =PIT.PE_PERSON_ID (+)
Columns
Name |
PERSON_ID |
BASE_ID |
PERSON_NUMBER |
PERSON_NAME |
API_PERSON_ID |
DATE_OF_BIRTH |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |