APPS.PJI_EXTRACTION_UTIL dependencies on PA_IMPLEMENTATIONS_ALL

Line 207: from PA_IMPLEMENTATIONS_ALL

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

Line 224: PA_IMPLEMENTATIONS_ALL imp

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

Line 258: PA_IMPLEMENTATIONS_ALL imp,

254: min(glp.START_DATE) START_DATE,
255: max(glp.END_DATE) END_DATE,
256: fii.CALENDAR_ID
257: from
258: PA_IMPLEMENTATIONS_ALL imp,
259: GL_SETS_OF_BOOKS sob,
260: GL_PERIODS glp,
261: FII_TIME_CAL_NAME fii
262: where

Line 280: PA_IMPLEMENTATIONS_ALL imp,

276: min(glp.START_DATE) START_DATE,
277: max(glp.END_DATE) END_DATE,
278: fii.CALENDAR_ID
279: from
280: PA_IMPLEMENTATIONS_ALL imp,
281: GL_PERIODS glp,
282: FII_TIME_CAL_NAME fii
283: where
284: imp.PA_PERIOD_TYPE = glp.PERIOD_TYPE and

Line 326: PA_IMPLEMENTATIONS_ALL imp,

322: min(glp.START_DATE) START_DATE,
323: max(glp.END_DATE) END_DATE,
324: fii.CALENDAR_ID
325: from
326: PA_IMPLEMENTATIONS_ALL imp,
327: GL_SETS_OF_BOOKS sob,
328: GL_PERIODS glp,
329: FII_TIME_CAL_NAME fii
330: where

Line 348: PA_IMPLEMENTATIONS_ALL imp,

344: min(glp.START_DATE) START_DATE,
345: max(glp.END_DATE) END_DATE,
346: fii.CALENDAR_ID
347: from
348: PA_IMPLEMENTATIONS_ALL imp,
349: GL_PERIODS glp,
350: FII_TIME_CAL_NAME fii
351: where
352: imp.PA_PERIOD_TYPE = glp.PERIOD_TYPE and