APPS.PA_PURGE_COSTING dependencies on PA_ROUTINGS_AR

Line 3713: x_err_stage := 'PA_Routings1: Before inserting records into PA_Routings_AR' ;

3709: -- in the commit size.
3710:
3711: l_commit_size := p_commit_size / 2 ;
3712:
3713: x_err_stage := 'PA_Routings1: Before inserting records into PA_Routings_AR' ;
3714: insert into PA_Routings_AR
3715: (
3716: Expenditure_Id,
3717: Routed_From_Person_Id,

Line 3714: insert into PA_Routings_AR

3710:
3711: l_commit_size := p_commit_size / 2 ;
3712:
3713: x_err_stage := 'PA_Routings1: Before inserting records into PA_Routings_AR' ;
3714: insert into PA_Routings_AR
3715: (
3716: Expenditure_Id,
3717: Routed_From_Person_Id,
3718: Start_Date,

Line 3767: from pa_routings_ar roar

3763:
3764: delete from pa_routings ro
3765: where (ro.expenditure_id, ro.start_date ) in
3766: ( select roar.expenditure_id, roar.start_date
3767: from pa_routings_ar roar
3768: where roar.purge_project_id = p_project_id
3769: ) ;
3770:
3771: l_NoOfRecordsDel := SQL%ROWCOUNT ;