[Home] [Help]
View: IGS_HE_UT_PRS_CALCS_V
Product: | IGS - Student System (Obsolete) |
Description: | Selects Persons and the Tariff Calculation Types for which the Process has been run |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UPC.ROWID ROW_ID
, UPC.TARIFF_CALC_TYPE_CD
, UPC.PERSON_ID
, UCT.TARIFF_CALC_TYPE_DESC
, UPC.CALC_DATE
, IGS_HE_UCAS_TARIFF_PKG.TOTAL_INTERNAL_TARIFF (UPC.TARIFF_CALC_TYPE_CD
, UPC.PERSON_ID) TOTAL_TARIFF
, UPC.CREATED_BY
, UPC.CREATION_DATE
, UPC.LAST_UPDATED_BY
, UPC.LAST_UPDATE_DATE
, UPC.LAST_UPDATE_LOGIN
FROM IGS_HE_UT_PRS_CALCS UPC
, IGS_HE_UT_CALC_TYPE UCT
WHERE UPC.TARIFF_CALC_TYPE_CD = UCT.TARIFF_CALC_TYPE_CD
Columns
Name |
ROW_ID |
TARIFF_CALC_TYPE_CD |
PERSON_ID |
TARIFF_CALC_TYPE_DESC |
CALC_DATE |
TOTAL_TARIFF |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |