APPS.PA_PURGE_SUMMARY dependencies on PA_PRJ_ACCUM_ACTUALS_AR

Line 848: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_ACTUALS_AR') ;

844:
845: l_commit_size := p_commit_size / 2 ;
846:
847:
848: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_ACTUALS_AR') ;
849:
850: INSERT INTO PA_PRJ_ACCUM_ACTUALS_AR
851: (
852: PURGE_BATCH_ID,

Line 850: INSERT INTO PA_PRJ_ACCUM_ACTUALS_AR

846:
847:
848: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_ACTUALS_AR') ;
849:
850: INSERT INTO PA_PRJ_ACCUM_ACTUALS_AR
851: (
852: PURGE_BATCH_ID,
853: PURGE_RELEASE,
854: PURGE_PROJECT_ID,

Line 992: PA_PRJ_ACCUM_ACTUALS_AR paa2

988: DELETE FROM pa_project_accum_actuals paa
989: WHERE (paa.rowid) IN
990: ( SELECT paa1.rowid
991: FROM pa_project_accum_Actuals paa1,
992: PA_PRJ_ACCUM_ACTUALS_AR paa2
993: WHERE paa1.project_accum_id = paa2.project_accum_id
994: AND paa2.purge_project_id = p_project_id
995: ) ;
996: */

Line 1000: FROM PA_PRJ_ACCUM_ACTUALS_AR paa2

996: */
997: DELETE FROM pa_project_accum_actuals paa
998: WHERE (paa.project_accum_id) IN
999: ( SELECT paa2.project_accum_id
1000: FROM PA_PRJ_ACCUM_ACTUALS_AR paa2
1001: WHERE paa2.purge_project_id = p_project_id
1002: ) ;
1003: /*Code Changes for Bug No.2984871 start */
1004: l_NoOfRecordsDel := SQL%ROWCOUNT ;