APPS.PA_PAXMGPSD_XMLP_PKG dependencies on PA_PERIODS

Line 176: PA_PERIODS

172: START_DATE,
173: END_DATE
174: INTO PERNAME,ST_DATE,E_DATE
175: FROM
176: PA_PERIODS
177: WHERE TRUNC(SYSDATE) between TRUNC(START_DATE)
178: AND TRUNC(END_DATE);
179: ELSE
180: SELECT

Line 186: PA_PERIODS

182: START_DATE,
183: END_DATE
184: INTO PERNAME,ST_DATE,E_DATE
185: FROM
186: PA_PERIODS
187: WHERE PERIOD_NAME = PA_PERIOD;
188: END IF;
189: C_START_DATE := ST_DATE;
190: C_END_DATE := E_DATE;