APPS.PA_ACCUM_UTILS dependencies on PA_PERIOD_PROCESS_PKG

Line 259: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
256: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
257: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
258: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
259: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
260: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
261: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS'
262: AND PAL.LOOKUP_CODE = PAP.STATUS
263: AND PAP.current_pa_period_flag = 'Y';

Line 488: WHERE gps.application_id = pa_period_process_pkg.application_id

484: INTO
485: x_period_yr_start_date
486: FROM
487: GL_PERIOD_STATUSES gps, pa_implementations imp
488: WHERE gps.application_id = pa_period_process_pkg.application_id
489: and gps.set_of_books_id = imp.set_of_books_id
490: and gps.period_name = x_current_gl_period;
491:
492: EXCEPTION

Line 1266: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id

1262: AND PRAD.PROJECT_ID = PTA.PROJECT_ID
1263: AND PTA.PA_PERIOD = PAP.PERIOD_NAME
1264: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1265: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1266: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id
1267: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
1268: ORDER BY DECODE(x_period_type,'P',PAP.START_DATE,'G',GLP.START_DATE,PAP.START_DATE);
1269: */
1270:

Line 1291: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id

1287: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID
1288: AND PRAD.PROJECT_ID = PTA.PROJECT_ID
1289: AND PTA.GL_PERIOD = GLP.PERIOD_NAME
1290: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1291: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id
1292: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
1293: ORDER BY GLP.START_DATE;
1294:
1295: CURSOR selresaccums_p IS

Line 1316: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id

1312: AND PRAD.PROJECT_ID = PTA.PROJECT_ID
1313: AND PTA.PA_PERIOD = PAP.PERIOD_NAME
1314: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1315: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1316: AND GLP.APPLICATION_ID = pa_period_process_pkg.application_id
1317: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
1318: ORDER BY PAP.START_DATE;
1319:
1320: gresaccumrec selresaccums_g%ROWTYPE;

Line 1479: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

1475: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
1476: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
1477: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1478: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1479: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
1480: AND GLP.ADJUSTMENT_PERIOD_FLAG = 'N'
1481: AND PAL.LOOKUP_TYPE = 'CLOSING STATUS'
1482: AND PAL.LOOKUP_CODE = PAP.STATUS
1483: AND PAP.current_pa_period_flag = 'Y' ;