APPS.PA_PURGE_COSTING dependencies on PA_ROUTINGS_AR

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

3705: -- in the commit size.
3706:
3707: l_commit_size := p_commit_size / 2 ;
3708:
3709: x_err_stage := 'PA_Routings1: Before inserting records into PA_Routings_AR' ;
3710: insert into PA_Routings_AR
3711: (
3712: Expenditure_Id,
3713: Routed_From_Person_Id,

Line 3710: insert into PA_Routings_AR

3706:
3707: l_commit_size := p_commit_size / 2 ;
3708:
3709: x_err_stage := 'PA_Routings1: Before inserting records into PA_Routings_AR' ;
3710: insert into PA_Routings_AR
3711: (
3712: Expenditure_Id,
3713: Routed_From_Person_Id,
3714: Start_Date,

Line 3763: from pa_routings_ar roar

3759:
3760: delete from pa_routings ro
3761: where (ro.expenditure_id, ro.start_date ) in
3762: ( select roar.expenditure_id, roar.start_date
3763: from pa_routings_ar roar
3764: where roar.purge_project_id = p_project_id
3765: ) ;
3766:
3767: l_NoOfRecordsDel := SQL%ROWCOUNT ;