SELECT C.APPROVER_ID , A.VC_PLAN_ID , A2.LANGUAGE_CD , A2.DESCR50 FROM PS_VC_PLAN_TBL A , PS_VC_PLAN_LANG A2 , PS_VC_ELIGSTAT_TBL B , PS_VC_PLAN_EFFDT C , PS_VC_PAYPRD_TBL D WHERE B.VC_PRCS_COMPLETE = 'Y' AND A.VC_PLAN_ID = B.VC_PLAN_ID AND A.VC_PLAN_ID = A2.VC_PLAN_ID AND B.VC_PLAN_ID = C.VC_PLAN_ID AND %EffdtCheck(VC_PLAN_EFFDT, C, D.PRD_END_DT) AND C.EFF_STATUS = 'A' AND C.VC_APPROVAL_IND = 'Y' AND C.VC_PLAN_ID = D.VC_PLAN_ID AND B.VC_PAYOUT_PRD_ID = D.VC_PAYOUT_PRD_ID AND A.VC_PLAN_MEM_CRIT IN ('A','E') AND EXISTS ( SELECT 'X' FROM PS_VC_AWARD_VW AV WHERE AV.VC_PLAN_ID = B.VC_PLAN_ID AND AV.VC_PAYOUT_PRD_ID = B.VC_PAYOUT_PRD_ID)
|