APPS.PA_PAXMGTSD_XMLP_PKG dependencies on PA_PERIODS

Line 182: PA_PERIODS

178: START_DATE,
179: END_DATE
180: INTO PERNAME,ST_DATE,E_DATE
181: FROM
182: PA_PERIODS
183: WHERE TRUNC(SYSDATE) between TRUNC(START_DATE)
184: AND TRUNC(END_DATE);
185: ELSE
186: SELECT

Line 192: PA_PERIODS

188: START_DATE,
189: END_DATE
190: INTO PERNAME,ST_DATE,E_DATE
191: FROM
192: PA_PERIODS
193: WHERE PERIOD_NAME = PA_PERIOD;
194: END IF;
195: C_START_DATE := to_char(ST_DATE,'DD-MON-YY');
196: C_END_DATE := to_char(E_DATE,'DD-MON-YY');

Line 277: PA_PERIODS

273: START_DATE,
274: END_DATE
275: INTO L_PRD_START_DATE,L_PRD_END_DATE
276: FROM
277: PA_PERIODS
278: WHERE PERIOD_NAME = GET_PERIOD_AMT.PERIOD_NAME
279: AND PERIOD_NAME IS NOT NULL;
280: PA_ACCUM_API.GET_PROJ_ACCUM_ACTUALS(PROJECT_ID2
281: ,X_TASK_ID