APPS.PA_ACCUM_API dependencies on PA_TXN_ACCUM_DETAILS

Line 199: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

195: )
196: )
197: )
198: AND EXISTS
199: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
200: WHERE
201: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
202: )
203: AND pta.pa_period = x_from_period_name ;

Line 255: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

251: )
252: )
253: )
254: AND EXISTS
255: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
256: WHERE
257: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
258: )
259: AND pta.gl_period = x_from_period_name ; -- Added for bug 4390421

Line 478: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

474: SYS.DUAL */
475: )
476: )
477: AND EXISTS
478: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
479: WHERE
480: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
481: )
482: AND x_period_type = 'P'

Line 563: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

559: SYS.DUAL */
560: )
561: )
562: AND EXISTS
563: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
564: WHERE
565: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
566: )
567: /* AND pp.gl_period_name = glp.period_name commented for bug 2922974 Added for bug 1631100 performance tuning