Product: | IGS - Student System |
---|---|
Description: | To capture the Timeslot Parameters of running the process. |
Implementation/DBA Data: | APPS.IGS_EN_TIMESLOT_PARA_V |
SELECT TSP.ROWID
, TSP.IGS_EN_TIMESLOT_PARA_ID
, TSP.PROGRAM_TYPE_GROUP_CD
, PTG.DESCRIPTION
, TSP.CAL_TYPE
, TSP.SEQUENCE_NUMBER
, TSP.TIMESLOT_CALENDAR
, TSP.TIMESLOT_ST_TIME
, TSP.TIMESLOT_END_TIME
, CT.DESCRIPTION
, CI.START_DT
, CI.END_DT
, TSP.STUDENT_TYPE
, LKUP.MEANING
, TSP.TS_MODE
, TSP.MAX_HEAD_COUNT
, TSP.LENGTH_OF_TIME
, TSP.CREATED_BY
, TSP.CREATION_DATE
, TSP.LAST_UPDATED_BY
, TSP.LAST_UPDATE_DATE
, TSP.LAST_UPDATE_LOGIN
, TSP.ORG_ID
FROM IGS_EN_TIMESLOT_PARA TSP
, IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_PS_TYPE_GRP PTG
, IGS_LOOKUPS_VIEW LKUP
WHERE TSP.CAL_TYPE = CI.CAL_TYPE
AND TSP.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CI.CAL_TYPE = CT.CAL_TYPE
AND TSP.PROGRAM_TYPE_GROUP_CD = PTG.COURSE_TYPE_GROUP_CD
AND (LKUP.LOOKUP_TYPE = 'TIMESLOT_STUDENT_TYPE'
AND TSP.STUDENT_TYPE = LKUP.LOOKUP_CODE)
AND NVL(TSP.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)