Product: | IGF - Financial Aid |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.IGF_AP_ADM_SETUP_V |
SELECT ADMSETUP.ROW_ID
, ADMSETUP.ADM_PROCESS_SEQ
, ADMSETUP.ADM_APPL_STAT
, ADMAPPL.DESCRIPTION
, ADMSETUP.ADM_OUTCOME_STAT
, ADMOUT.DESCRIPTION
, ADMSETUP.ADM_FEE_STAT
, ADMFEE.DESCRIPTION
, ADMSETUP.ADM_OFFER_RESP_STAT
, ADMRESP.DESCRIPTION
, ADMSETUP.CREATED_BY
, ADMSETUP.CREATION_DATE
, ADMSETUP.LAST_UPDATED_BY
, ADMSETUP.LAST_UPDATE_DATE
, ADMSETUP.LAST_UPDATE_LOGIN
FROM IGF_AP_ADM_SETUP ADMSETUP
, IGS_AD_OU_STAT ADMOUT
, IGS_AD_OFR_RESP_STAT ADMRESP
, IGS_AD_FEE_STAT ADMFEE
, IGS_AD_APPL_STAT ADMAPPL
WHERE ADMSETUP.ADM_APPL_STAT =ADMAPPL.ADM_APPL_STATUS(+)
AND ADMSETUP.ADM_OUTCOME_STAT=ADMOUT.ADM_OUTCOME_STATUS(+)
AND ADMSETUP.ADM_OFFER_RESP_STAT=ADMRESP.ADM_OFFER_RESP_STATUS(+)
AND ADMSETUP.ADM_FEE_STAT= ADMFEE.ADM_FEE_STATUS(+)