APPS.PJI_EXTRACTION_UTIL dependencies on PA_IMPLEMENTATIONS_ALL

Line 208: from PA_IMPLEMENTATIONS_ALL

204: from
205: dual
206: where
207: not exists (select ORG_ID
208: from PA_IMPLEMENTATIONS_ALL
209: where ORG_ID is null) and
210: -1 not in (select ORG_ID
211: from PJI_ORG_EXTR_INFO)
212: union all

Line 225: PA_IMPLEMENTATIONS_ALL imp

221: to_number(null),
222: to_number(null),
223: to_number(null)
224: from
225: PA_IMPLEMENTATIONS_ALL imp
226: where
227: imp.ORG_ID not in (select ORG_ID
228: from PJI_ORG_EXTR_INFO);
229:

Line 259: PA_IMPLEMENTATIONS_ALL imp,

255: min(glp.START_DATE) START_DATE,
256: max(glp.END_DATE) END_DATE,
257: fii.CALENDAR_ID
258: from
259: PA_IMPLEMENTATIONS_ALL imp,
260: GL_SETS_OF_BOOKS sob,
261: GL_PERIODS glp,
262: PA_TIME_CAL_NAME fii /* Modified for bug 12979524 */
263: where

Line 281: PA_IMPLEMENTATIONS_ALL imp,

277: min(glp.START_DATE) START_DATE,
278: max(glp.END_DATE) END_DATE,
279: fii.CALENDAR_ID
280: from
281: PA_IMPLEMENTATIONS_ALL imp,
282: GL_PERIODS glp,
283: PA_TIME_CAL_NAME fii /* Modified for bug 12979524 */
284: where
285: imp.PA_PERIOD_TYPE = glp.PERIOD_TYPE and

Line 327: PA_IMPLEMENTATIONS_ALL imp,

323: min(glp.START_DATE) START_DATE,
324: max(glp.END_DATE) END_DATE,
325: fii.CALENDAR_ID
326: from
327: PA_IMPLEMENTATIONS_ALL imp,
328: GL_SETS_OF_BOOKS sob,
329: GL_PERIODS glp,
330: PA_TIME_CAL_NAME fii /* Modified for bug 12979524 */
331: where

Line 349: PA_IMPLEMENTATIONS_ALL imp,

345: min(glp.START_DATE) START_DATE,
346: max(glp.END_DATE) END_DATE,
347: fii.CALENDAR_ID
348: from
349: PA_IMPLEMENTATIONS_ALL imp,
350: GL_PERIODS glp,
351: PA_TIME_CAL_NAME fii /* Modified for bug 12979524 */
352: where
353: imp.PA_PERIOD_TYPE = glp.PERIOD_TYPE and