View: IGF_AP_ATTEND_MAP

Product:	IGF - Financial Aid
Description:	Stores the mapping from Attendance Types, which are user-defined in OSS to the Attendance Types(enrollment status of Pell Grants/FFELP Loans/Application Processing) which is used in Financial Aid
Implementation/DBA Data:	APPS.IGF_AP_ATTEND_MAP

View Text

SELECT ATM.ROWID
, ATM.ATM_ID
, ATM.ATTENDANCE_TYPE
, ATM.PELL_ATT_CODE
, ATM.CL_ATT_CODE
, ATM.AP_ATT_CODE
, ATM.ORG_ID
, ATM.CREATED_BY
, ATM.CREATION_DATE
, ATM.LAST_UPDATED_BY
, ATM.LAST_UPDATE_DATE
, ATM.LAST_UPDATE_LOGIN
, ATM.CAL_TYPE
, ATM.SEQUENCE_NUMBER
FROM IGF_AP_ATTEND_MAP_ALL ATM
WHERE NVL(ATM.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns