VIEW: APPS.IGS_DA_XML_GPA_V

Source

View Text - Preformatted

SELECT ins.stat_type, CI.ALTERNATE_CODE, 'CUMULATIVE', IGS_DA_XML_PKG.GET_CUM_ATTEMPTED_CP(drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, ins.stat_type), IGS_DA_XML_PKG.GET_CUM_EARNED_CP(drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, ins.stat_type), IGS_DA_XML_PKG.GET_CUM_GPA(drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, ins.stat_type), IGS_DA_XML_PKG.GET_CUM_GPA_CP(drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, ins.stat_type), IGS_DA_XML_PKG.GET_CUM_GPA_QP(drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, ins.stat_type), drs.batch_id, drs.person_id, drs.program_code, ci.cal_type, ci.sequence_number, drs.igs_da_req_stdnts_id from igs_ca_inst_all ci, igs_da_req_stdnts drs, igs_pr_inst_stat ins WHERE ins.standard_ind = 'Y' and ins.timeframe IN ('CUMULATIVE', 'BOTH')

View Text - HTML Formatted

SELECT INS.STAT_TYPE
, CI.ALTERNATE_CODE
, 'CUMULATIVE'
, IGS_DA_XML_PKG.GET_CUM_ATTEMPTED_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_EARNED_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA_CP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, IGS_DA_XML_PKG.GET_CUM_GPA_QP(DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, INS.STAT_TYPE)
, DRS.BATCH_ID
, DRS.PERSON_ID
, DRS.PROGRAM_CODE
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, DRS.IGS_DA_REQ_STDNTS_ID
FROM IGS_CA_INST_ALL CI
, IGS_DA_REQ_STDNTS DRS
, IGS_PR_INST_STAT INS
WHERE INS.STANDARD_IND = 'Y'
AND INS.TIMEFRAME IN ('CUMULATIVE'
, 'BOTH')