View: IGF_SE_AUTHORIZATION_V

Product:	IGF - Financial Aid
Description:	Public view to derive active work authorizations
Implementation/DBA Data:	APPS.IGF_SE_AUTHORIZATION_V

View Text

SELECT SE.AUTH_ID AUTHORIZATION_ID
, SE.PERSON_ID PERSON_ID
, SE.ACCEPTED_AMNT AUTHORIZED_AMT
, SE.AUTHORIZATION_DATE
, SE.FIRST_NAME PERSON_FIRST_NAME_TXT
, SE.LAST_NAME PERSON_LAST_NAME_TXT
, SE.BIRTH_DT BIRTH_DATE
, SE.SSN_NO SOCIAL_SECURITY_NUMBER
, SE.FUND_ID
, FM.FUND_CODE FUND_CODE_TXT
, LK1.LOOKUP_CODE SYSTEM_FUND_SOURCE_CODE
, LK1.MEANING SYSTEM_FUND_SOURCE_NAME
, FC.FUND_TYPE FUND_TYPE_TXT
, FC.SYS_FUND_TYPE SYSTEM_FUND_TYPE_CODE
, LK2.MEANING SYSTEM_FUND_TYPE_NAME
, SE.AW_CAL_TYPE
, SE.AW_SEQUENCE_NUMBER
, IGF_SL_LAR_CREATION.GET_LOAN_START_DT(SE.AWARD_ID) AUTHORIZATION_START_DATE
, IGF_SL_LAR_CREATION.GET_LOAN_END_DT(SE.AWARD_ID) AUTHORIZATION_END_DATE
FROM IGF_SE_AUTH SE
, IGF_AW_FUND_MAST_ALL FM
, IGF_AW_FUND_CAT FC
, IGF_LOOKUPS_VIEW LK1
, IGF_LOOKUPS_VIEW LK2
WHERE FM.FUND_ID = SE.FUND_ID
AND FM.FUND_CODE = FC.FUND_CODE
AND FC.FUND_SOURCE = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND LK2.LOOKUP_CODE = FC.SYS_FUND_TYPE
AND LK2.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND SE.FLAG = 'A'

Columns