APPS.PA_PURGE_SUMMARY dependencies on PA_PRJ_ACCUM_ACTUALS_AR

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

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

Line 851: INSERT INTO PA_PRJ_ACCUM_ACTUALS_AR

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

Line 993: PA_PRJ_ACCUM_ACTUALS_AR paa2

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

Line 1001: FROM PA_PRJ_ACCUM_ACTUALS_AR paa2

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