[Home] [Help]
90: CURSOR CUR_CMWHSE_ASC(V_ORGANIZATION_ID IN NUMBER,V_TRANS_DATE IN DATE) IS
91: SELECT
92: COST_ORGANIZATION_ID
93: FROM
94: CM_WHSE_ASC
95: WHERE ORGANIZATION_ID = V_ORGANIZATION_ID
96: AND EFF_START_DATE <= V_TRANS_DATE
97: AND EFF_END_DATE >= V_TRANS_DATE
98: AND DELETE_MARK = 0;