APPS.PA_PURGE_SUMMARY dependencies on PA_PRJ_ACCUM_COMMIT_AR

Line 309: INSERT INTO PA_PRJ_ACCUM_COMMIT_AR

305:
306: -- The archive table name is different from the original table to limit
307: -- table name to 30 characters.
308:
309: INSERT INTO PA_PRJ_ACCUM_COMMIT_AR
310: (
311: PURGE_BATCH_ID,
312: PURGE_RELEASE,
313: PURGE_PROJECT_ID,

Line 401: PA_PRJ_ACCUM_COMMIT_AR pac2

397: DELETE FROM pa_project_accum_commitments PAC
398: WHERE (pac.rowid) IN
399: ( SELECT pac1.rowid
400: FROM pa_project_accum_commitments pac1,
401: PA_PRJ_ACCUM_COMMIT_AR pac2
402: WHERE pac1.project_accum_id = pac2.project_accum_id
403: AND pac2.purge_project_id=p_project_id
404: ) ;
405: */

Line 409: FROM PA_PRJ_ACCUM_COMMIT_AR pac2

405: */
406: DELETE FROM pa_project_accum_commitments PAC
407: WHERE (pac.project_accum_id) IN
408: ( SELECT pac2.project_accum_id
409: FROM PA_PRJ_ACCUM_COMMIT_AR pac2
410: WHERE pac2.purge_project_id=p_project_id
411: ) ;
412: /*Code Changes for Bug No.2984871 start */
413: l_NoOfRecordsDel := SQL%ROWCOUNT ;