Screenshot:
Query:
- POPUP_WINTER_LOAN_PYMT_PRD_QRY
Query Details:
SELECT D.EMPLID, D.INSTITUTION, D.AID_YEAR, D.ACAD_CAREER, D.LOAN_TYPE, D.LN_APPL_SEQ, D.ITEM_TYPE, D.DISBURSEMENT_ID
FROM PS_STDNT_AWARDS A, PS_SCCPU_LNDSB_BND D
WHERE ( A.OFFER_AMOUNT > 0
AND A.DISBURSEMENT_PLAN IN ('QY','LY')
AND A.AID_YEAR = :1
AND A.INSTITUTION = 'UOD01'
AND A.ITEM_TYPE IN (SELECT B.ITEM_TYPE
FROM PS_ITEM_TYPE_FA B
WHERE B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_ITEM_TYPE_FA B_ED
WHERE B.SETID = B_ED.SETID
AND B.ITEM_TYPE = B_ED.ITEM_TYPE
AND B.AID_YEAR = B_ED.AID_YEAR
AND B_ED.EFFDT <= SYSDATE)
AND B.SETID = 'UOD01'
AND B.LOAN_PROGRAM = 'D'
AND B.AID_YEAR = :1)
AND A.EMPLID IN (SELECT C.EMPLID
FROM PS_STDNT_FA_TERM C
WHERE C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_STDNT_FA_TERM C_ED
WHERE C.EMPLID = C_ED.EMPLID
AND C.INSTITUTION = C_ED.INSTITUTION
AND C.STRM = C_ED.STRM
AND C_ED.EFFDT <= SYSDATE)
AND C.EFFSEQ =
(SELECT MAX(C_ES.EFFSEQ) FROM PS_STDNT_FA_TERM C_ES
WHERE C.EMPLID = C_ES.EMPLID
AND C.INSTITUTION = C_ES.INSTITUTION
AND C.STRM = C_ES.STRM
AND C.EFFDT = C_ES.EFFDT)
AND C.INSTITUTION = 'UOD01'
AND C.STRM = :2
AND C.UNT_TAKEN_FA > 0)
AND A.EMPLID = D.EMPLID
AND A.INSTITUTION = D.INSTITUTION
AND A.AID_YEAR = D.AID_YEAR
AND A.ITEM_TYPE = D.ITEM_TYPE
AND A.ACAD_CAREER = D.ACAD_CAREER
AND D.DISBURSEMENT_ID = '03')
ORDER BY 1