72: ,'YYYY-MM-DD') || 'T' || TO_CHAR(P2.END_DATE
73: ,'HH24:MI:SS')
74: INTO L_PERIOD_YEAR,PER_FROM_START_DATE,PER_TO_END_DATE,PERIOD_FROM_START_DATE,PERIOD_TO_END_DATE
75: FROM
76: GL_PERIODS P1,
77: GL_PERIODS P2
78: WHERE P1.PERIOD_SET_NAME = L_PERIOD_SET_NAME
79: AND P1.PERIOD_NAME = P_PERIOD_FROM
80: AND P2.PERIOD_SET_NAME = L_PERIOD_SET_NAME
73: ,'HH24:MI:SS')
74: INTO L_PERIOD_YEAR,PER_FROM_START_DATE,PER_TO_END_DATE,PERIOD_FROM_START_DATE,PERIOD_TO_END_DATE
75: FROM
76: GL_PERIODS P1,
77: GL_PERIODS P2
78: WHERE P1.PERIOD_SET_NAME = L_PERIOD_SET_NAME
79: AND P1.PERIOD_NAME = P_PERIOD_FROM
80: AND P2.PERIOD_SET_NAME = L_PERIOD_SET_NAME
81: AND P2.PERIOD_NAME = P_PERIOD_TO;
83: P1.PERIOD_NAME,
84: P1.ADJUSTMENT_PERIOD_FLAG
85: INTO FIRST_PERIOD_NAME,FIRST_PERIOD_ADJ_FLAG
86: FROM
87: GL_PERIODS P1
88: WHERE P1.PERIOD_SET_NAME = L_PERIOD_SET_NAME
89: AND P1.PERIOD_TYPE = L_PERIOD_TYPE
90: AND P1.PERIOD_YEAR = L_PERIOD_YEAR
91: AND P1.PERIOD_NUM = (
91: AND P1.PERIOD_NUM = (
92: SELECT
93: MIN(P2.PERIOD_NUM)
94: FROM
95: GL_PERIODS P2
96: WHERE P2.PERIOD_SET_NAME = L_PERIOD_SET_NAME
97: AND P2.PERIOD_TYPE = L_PERIOD_TYPE
98: AND P2.PERIOD_YEAR = L_PERIOD_YEAR );
99: /*SRW.REFERENCE(COA_ID)*/NULL;