Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view determines the elements range rate specific to a given fee category fee liability. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ERR.ROWID
, ERR.ERR_ID
, ERR.FEE_TYPE
, ERR.FEE_CAL_TYPE
, ERR.FEE_CI_SEQUENCE_NUMBER
, ERR.S_RELATION_TYPE
, ERR.RANGE_NUMBER
, ERR.RATE_NUMBER
, ERR.CREATE_DT
, ERR.FEE_CAT
, ERR.LOGICAL_DELETE_DT
, FAR.LOCATION_CD
, FAR.ATTENDANCE_TYPE
, FAR.ATTENDANCE_MODE
, FAR.ORDER_OF_PRECEDENCE
, FAR.GOVT_HECS_PAYMENT_OPTION
, FAR.GOVT_HECS_CNTRBTN_BAND
, FAR.CHG_RATE
, FAR.RESIDENCY_STATUS_CD DSP_RESIDENCY_STATUS_CD
, CC.MEANING DSP_RESIDENCY_STATUS
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, HP.PARTY_NUMBER
, FAR.CLASS_STANDING
, ERR.CREATED_BY
, ERR.CREATION_DATE
, ERR.LAST_UPDATED_BY
, ERR.LAST_UPDATE_DATE
, ERR.LAST_UPDATE_LOGIN
, FAR.UNIT_SET_CD
, FAR.US_VERSION_NUMBER
, FAR.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FAR.UNIT_CLASS
, FAR.UNIT_MODE
, FAR.UNIT_CD
, FAR.UNIT_VERSION_NUMBER
, FAR.UNIT_LEVEL
FROM IGS_FI_ELM_RANGE_RT ERR
, IGS_FI_FEE_AS_RATE FAR
, HZ_PARTIES HP
, IGS_LOOKUP_VALUES CC
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE FAR.FEE_TYPE = ERR.FEE_TYPE
AND FAR.FEE_CAL_TYPE = ERR.FEE_CAL_TYPE
AND FAR.FEE_CI_SEQUENCE_NUMBER = ERR.FEE_CI_SEQUENCE_NUMBER
AND FAR.RATE_NUMBER = ERR.RATE_NUMBER
AND FAR.S_RELATION_TYPE = ERR.S_RELATION_TYPE
AND (FAR.FEE_CAT = ERR.FEE_CAT OR (FAR.FEE_CAT IS NULL
AND ERR.FEE_CAT IS NULL))
AND FAR.ORG_PARTY_ID = HP.PARTY_ID (+)
AND FAR.RESIDENCY_STATUS_CD = CC.LOOKUP_CODE (+)
AND CC.LOOKUP_TYPE(+) = 'PE_RES_STATUS'
AND FAR.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)