Body
Screenshot:
Query:
UDSFS_POPUP_GRAD_BUDGET_UPD
Query Details:
SELECT A.EMPLID, A.INSTITUTION, A.STRM, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFFSEQ
FROM PS_SCCPU_FATRM_BND A
WHERE ( A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_SCCPU_FATRM_BND A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.INSTITUTION = A_ED.INSTITUTION
AND A.STRM = A_ED.STRM
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_SCCPU_FATRM_BND A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.INSTITUTION = A_ES.INSTITUTION
AND A.STRM = A_ES.STRM
AND A.EFFDT = A_ES.EFFDT)
AND A.STRM = :1
AND A.INSTITUTION = 'UOD01'
AND A.EMPLID IN (SELECT B.EMPLID
FROM PS_STDNT_BUDGET_IT B
WHERE B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_STDNT_BUDGET_IT B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.INSTITUTION = B_ED.INSTITUTION
AND B.AID_YEAR = B_ED.AID_YEAR
AND B.ACAD_CAREER = B_ED.ACAD_CAREER
AND B.STRM = B_ED.STRM
AND B_ED.EFFDT <= SYSDATE)
AND B.EFFSEQ =
(SELECT MAX(B_ES.EFFSEQ) FROM PS_STDNT_BUDGET_IT B_ES
WHERE B.EMPLID = B_ES.EMPLID
AND B.INSTITUTION = B_ES.INSTITUTION
AND B.AID_YEAR = B_ES.AID_YEAR
AND B.ACAD_CAREER = B_ES.ACAD_CAREER
AND B.STRM = B_ES.STRM
AND B.EFFDT = B_ES.EFFDT)
AND B.STRM = :1
AND B.ACAD_CAREER = 'GRAD'
AND B.BUDGET_ITEM_AMOUNT > 0)
AND A.EMPLID IN (SELECT C.EMPLID
FROM PS_ACAD_PROG C
WHERE C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_ACAD_PROG C_ED
WHERE C.EMPLID = C_ED.EMPLID
AND C.ACAD_CAREER = C_ED.ACAD_CAREER
AND C.STDNT_CAR_NBR = C_ED.STDNT_CAR_NBR
AND C_ED.EFFDT <= SYSDATE)
AND C.EFFSEQ =
(SELECT MAX(C_ES.EFFSEQ) FROM PS_ACAD_PROG C_ES
WHERE C.EMPLID = C_ES.EMPLID
AND C.ACAD_CAREER = C_ES.ACAD_CAREER
AND C.STDNT_CAR_NBR = C_ES.STDNT_CAR_NBR
AND C.EFFDT = C_ES.EFFDT)
AND C.ACAD_CAREER = 'GRAD'
AND C.PROG_STATUS IN ('AC','AD','PM')))