APPS.JL_JLCLGCAL_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 86: GL_PERIOD_STATUSES

82: SELECT
83: EFFECTIVE_PERIOD_NUM
84: INTO EFF_PERIOD_NUM
85: FROM
86: GL_PERIOD_STATUSES
87: WHERE APPLICATION_ID = 101
88: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
89: AND UPPER(PERIOD_NAME) = UPPER(P_START_PERIOD);
90: RETURN (EFF_PERIOD_NUM);

Line 106: GL_PERIOD_STATUSES

102: SELECT
103: EFFECTIVE_PERIOD_NUM
104: INTO EFF_PERIOD_NUM
105: FROM
106: GL_PERIOD_STATUSES
107: WHERE APPLICATION_ID = 101
108: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
109: AND UPPER(PERIOD_NAME) = UPPER(P_END_PERIOD);
110: RETURN (EFF_PERIOD_NUM);