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 1739: -- delete from pa_ind_cost_multipliers

1735: -- anlee
1736: -- Commenting out for performance bug 2800129
1737: -- Delete ind cost multipliers, details of ind rate sch revisions
1738: -- x_err_stage := 'Delete ind cost multiplier for task '|| x_task_id;
1739: -- delete from pa_ind_cost_multipliers
1740: -- where ind_rate_sch_revision_id in
1741: -- (select rev.ind_rate_sch_revision_id
1742: -- from pa_ind_rate_sch_revisions rev, pa_ind_rate_schedules sch
1743: -- where rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 1898: from pa_ind_cost_multipliers icm

1894: if ( l_ind_rate_sch_rev_id_tab.count > 0 )
1895: then
1896: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1897: delete
1898: from pa_ind_cost_multipliers icm
1899: where icm.ind_rate_sch_revision_id = l_ind_rate_sch_rev_id_tab(i)
1900: ;
1901: forall i in l_ind_rate_sch_rev_id_tab.first .. l_ind_rate_sch_rev_id_tab.last
1902: delete