POPUP_WINTER_LOAN_PYMT_PRD

Run control documentation for POPUP_WINTER_LOAN_PYMT_PRD, used to update full year payment period start dates for the combined winter term.

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