APPS.PA_PROJECT_CORE dependencies on PA_IND_COST_MULTIPLIERS

Line 520: delete from pa_ind_cost_multipliers

516: where rev.ind_rate_sch_id = sch.ind_rate_sch_id
517: and sch.project_id = x_project_id);
518:
519: -- Delete ind cost multipliers, details of ind rate sch revisions
520: delete from pa_ind_cost_multipliers
521: where ind_rate_sch_revision_id in
522: (select rev.ind_rate_sch_revision_id
523: from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
524: where rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 1723: -- delete from pa_ind_cost_multipliers

1719: -- anlee
1720: -- Commenting out for performance bug 2800129
1721: -- Delete ind cost multipliers, details of ind rate sch revisions
1722: -- x_err_stage := 'Delete ind cost multiplier for task '|| x_task_id;
1723: -- delete from pa_ind_cost_multipliers
1724: -- where ind_rate_sch_revision_id in
1725: -- (select rev.ind_rate_sch_revision_id
1726: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
1727: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 1882: from pa_ind_cost_multipliers icm

1878: if ( l_ind_rate_sch_rev_id_tab.count > 0 )
1879: then
1880: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1881: delete
1882: from pa_ind_cost_multipliers icm
1883: where icm.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1884: ;
1885: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1886: delete