GPMX_CAL_FN_VW(SQL View) |
Index Back |
---|---|
Finalized Calendar Groups ViewFinalized Calendar Groups View |
SELECT A.CAL_RUN_ID ,A.DESCR FROM PS_GP_CAL_RUN A WHERE A.RUN_FINALIZED_IND = 'Y' AND A.COUNTRY = 'MEX' AND(EXISTS ( SELECT B.CAL_RUN_ID FROM PS_GPMX_RC_IAC_TBL B WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND B.RUN_FINAL_IND = 'N') OR NOT EXISTS( SELECT C.CAL_RUN_ID FROM PS_GPMX_RC_IAC_TBL C WHERE A.CAL_RUN_ID = C.CAL_RUN_ID AND C.RUN_FINAL_IND = 'Y')) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |