VIEW: APPS.IGF_SE_AUTH_V

Source

View Text - Preformatted

SELECT distinct SAI.AUTHORIZATION_DATE auth_date, sai.rowid, SAI.SEQUENCE_NO, SAI.AUTH_ID, SAI.FLAG, SAI.PERSON_ID , SAI.FIRST_NAME , SAI.LAST_NAME , SAI.ADDRESS1 , SAI.ADDRESS2 , SAI.ADDRESS3 , SAI.ADDRESS4 , SAI.CITY , SAI.STATE , SAI.PROVINCE , SAI.COUNTY , SAI.COUNTRY , sai.SEX , SAI.BIRTH_DT, SAI.SSN_NO , sai.MARITAL_STATUS , SAI.VISA_TYPE , SAI.VISA_CATEGORY , SAI.VISA_NUMBER , SAI.VISA_EXPIRY_DT , SAI.ENTRY_DATE , SAI.FUND_ID , fm.fund_code, FM.DESCRIPTION, NULL, NULL, SAI.THRESHOLD_PERCT , SAI.THRESHOLD_VALUE , NULL, NULL, SAI.ACCEPTED_AMNT , SAI.AW_CAL_TYPE, SAI.AW_SEQUENCE_NUMBER, CA1.ALTERNATE_CODE AW_ALTERNATE_CODE, CA1.START_DT AW_START_DATE, CA1.END_DT AW_END_DATE, NULL, NULL, NULL, NULL, NULL, sai.CREATED_BY, sai.CREATION_DATE, sai.LAST_UPDATED_BY, sai.LAST_UPDATE_DATE , Sai.LAST_UPDATE_LOGIN, sai.REQUEST_ID , sai.PROGRAM_APPLICATION_ID, sai.PROGRAM_ID , sai.PROGRAM_UPDATE_DATE , IGF_SL_LAR_CREATION.get_loan_start_dt(awd.award_id), IGF_SL_LAR_CREATION.get_loan_end_dt(awd.award_id), SAI.AUTHORIZATION_DATE, SAI.NOTIFICATION_DATE, SAI.AWARD_ID FROM IGF_SE_AUTH SAI , IGS_CA_INST CA1, IGF_AW_FUND_MAST FM, IGF_AW_AWARD_ALL AWD WHERE AWD.AWARD_ID = SAI.AWARD_ID AND CA1.CAL_TYPE = SAI.AW_CAL_TYPE and CA1.SEQUENCE_NUMBER = SAI.AW_SEQUENCE_NUMBER AND FM.FUND_ID = SAI.FUND_ID

View Text - HTML Formatted

SELECT DISTINCT SAI.AUTHORIZATION_DATE AUTH_DATE
, SAI.ROWID
, SAI.SEQUENCE_NO
, SAI.AUTH_ID
, SAI.FLAG
, SAI.PERSON_ID
, SAI.FIRST_NAME
, SAI.LAST_NAME
, SAI.ADDRESS1
, SAI.ADDRESS2
, SAI.ADDRESS3
, SAI.ADDRESS4
, SAI.CITY
, SAI.STATE
, SAI.PROVINCE
, SAI.COUNTY
, SAI.COUNTRY
, SAI.SEX
, SAI.BIRTH_DT
, SAI.SSN_NO
, SAI.MARITAL_STATUS
, SAI.VISA_TYPE
, SAI.VISA_CATEGORY
, SAI.VISA_NUMBER
, SAI.VISA_EXPIRY_DT
, SAI.ENTRY_DATE
, SAI.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION
, NULL
, NULL
, SAI.THRESHOLD_PERCT
, SAI.THRESHOLD_VALUE
, NULL
, NULL
, SAI.ACCEPTED_AMNT
, SAI.AW_CAL_TYPE
, SAI.AW_SEQUENCE_NUMBER
, CA1.ALTERNATE_CODE AW_ALTERNATE_CODE
, CA1.START_DT AW_START_DATE
, CA1.END_DT AW_END_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, SAI.CREATED_BY
, SAI.CREATION_DATE
, SAI.LAST_UPDATED_BY
, SAI.LAST_UPDATE_DATE
, SAI.LAST_UPDATE_LOGIN
, SAI.REQUEST_ID
, SAI.PROGRAM_APPLICATION_ID
, SAI.PROGRAM_ID
, SAI.PROGRAM_UPDATE_DATE
, IGF_SL_LAR_CREATION.GET_LOAN_START_DT(AWD.AWARD_ID)
, IGF_SL_LAR_CREATION.GET_LOAN_END_DT(AWD.AWARD_ID)
, SAI.AUTHORIZATION_DATE
, SAI.NOTIFICATION_DATE
, SAI.AWARD_ID
FROM IGF_SE_AUTH SAI
, IGS_CA_INST CA1
, IGF_AW_FUND_MAST FM
, IGF_AW_AWARD_ALL AWD
WHERE AWD.AWARD_ID = SAI.AWARD_ID
AND CA1.CAL_TYPE = SAI.AW_CAL_TYPE
AND CA1.SEQUENCE_NUMBER = SAI.AW_SEQUENCE_NUMBER
AND FM.FUND_ID = SAI.FUND_ID