APPS.PA_PURGE_SUMMARY dependencies on PA_PRJ_ACCUM_BUDGETS_AR

Line 540: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_BUDGETS_AR') ;

536:
537: l_commit_size := p_commit_size / 2 ;
538:
539:
540: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_BUDGETS_AR') ;
541:
542: INSERT INTO PA_PRJ_ACCUM_BUDGETS_AR
543: (
544: PURGE_BATCH_ID,

Line 542: INSERT INTO PA_PRJ_ACCUM_BUDGETS_AR

538:
539:
540: pa_debug.debug( ' ->Before insert into PA_PRJ_ACCUM_BUDGETS_AR') ;
541:
542: INSERT INTO PA_PRJ_ACCUM_BUDGETS_AR
543: (
544: PURGE_BATCH_ID,
545: PURGE_RELEASE,
546: PURGE_PROJECT_ID,

Line 717: PA_PRJ_ACCUM_BUDGETS_AR pab2

713: DELETE FROM pa_project_accum_budgets pab
714: WHERE (pab.rowid) IN
715: ( SELECT pab1.rowid
716: FROM pa_project_accum_budgets pab1,
717: PA_PRJ_ACCUM_BUDGETS_AR pab2
718: WHERE pab1.project_accum_id = pab2.project_accum_id
719: AND pab1.budget_type_code=pab2.budget_type_code
720: AND pab2.purge_project_id=p_project_id
721: ) ;

Line 727: FROM PA_PRJ_ACCUM_BUDGETS_AR pab2

723:
724: DELETE FROM pa_project_accum_budgets pab
725: WHERE (pab.project_accum_id) IN
726: ( SELECT pab2.project_accum_id
727: FROM PA_PRJ_ACCUM_BUDGETS_AR pab2
728: WHERE pab.budget_type_code=pab2.budget_type_code
729: AND pab2.purge_project_id=p_project_id
730: ) ;
731: /*Code Changes for Bug No.2984871 start */