23: SELECT
24: NAME
25: INTO DATA_ACCESS_SET_NAME
26: FROM
27: GL_ACCESS_SETS
28: WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: T_ERRORBUFFER := GL_MESSAGE.GET_MESSAGE('GL_PLL_INVALID_DATA_ACCESS_SET'
471: SELECT
472: PER.PERIOD_YEAR * 10000 + PER.PERIOD_NUM
473: INTO EPERNUM
474: FROM
475: GL_ACCESS_SETS AC,
476: GL_PERIODS PER
477: WHERE AC.ACCESS_SET_ID = ACC_SET_ID
478: AND PER.PERIOD_SET_NAME = AC.PERIOD_SET_NAME
479: AND PER.PERIOD_NAME = PNAME;