[Home] [Help]
681: IS
682:
683: CURSOR C_Get_Expiration_Date (l_Def_Cal VARCHAR2, l_Def_Per VARCHAR2) IS
684: SELECT End_Date
685: FROM GL_PERIODS_V
686: WHERE Period_Type = l_Def_Per
687: AND Period_Set_Name = l_Def_Cal
688: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
689: