APPS.PA_PROJECT_CORE dependencies on PA_IND_COMPILED_SETS

Line 502: from pa_ind_compiled_sets ics,

498: -- Delete compiled multipliers, details of compiled set id
499: delete from pa_compiled_multipliers
500: where ind_compiled_set_id in
501: (select ics.ind_compiled_set_id
502: from pa_ind_compiled_sets ics,
503: pa_ind_rate_sch_revisions rev,
504: pa_ind_rate_schedules sch
505: where ics.ind_rate_sch_revision_id =
506: rev.ind_rate_sch_revision_id

Line 511: delete from pa_ind_compiled_sets

507: and rev.ind_rate_sch_id = sch.ind_rate_sch_id
508: and sch.project_id = x_project_id);
509:
510: -- Delete compiled compiled set
511: delete from pa_ind_compiled_sets
512: where ind_rate_sch_revision_id in
513: (select rev.ind_rate_sch_revision_id
514: from pa_ind_rate_sch_revisions rev,
515: pa_ind_rate_schedules sch

Line 1707: -- from pa_ind_compiled_sets ics,

1703: -- x_err_stage := 'Delete compiled multiplier for task '|| x_task_id;
1704: -- delete from pa_compiled_multipliers
1705: -- where ind_compiled_set_id in
1706: -- (select ics.ind_compiled_set_id
1707: -- from pa_ind_compiled_sets ics,
1708: -- pa_ind_rate_sch_revisions rev,
1709: -- pa_ind_rate_schedules sch
1710: -- where ics.ind_rate_sch_revision_id =
1711: -- rev.ind_rate_sch_revision_id

Line 1723: -- delete from pa_ind_compiled_sets

1719: -- anlee
1720: -- Commenting out for performance bug 2800129
1721: -- Delete compiled compiled set
1722: -- x_err_stage := 'Delete compiled sets for task '|| x_task_id;
1723: -- delete from pa_ind_compiled_sets
1724: -- where ind_rate_sch_revision_id in
1725: -- (select rev.ind_rate_sch_revision_id
1726: -- from pa_ind_rate_sch_revisions rev,
1727: -- pa_ind_rate_schedules sch

Line 1790: from pa_ind_compiled_sets ics

1786: ;
1787: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1788: is
1789: select ics.ind_compiled_set_id
1790: from pa_ind_compiled_sets ics
1791: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1792: ;
1793: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1794: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1888: from pa_ind_compiled_sets ics

1884: where ind_compiled_set_id = l_ind_comp_set_id_tab(i)
1885: ;
1886: forall i in l_ind_comp_set_id_tab.first .. l_ind_comp_set_id_tab.last
1887: delete
1888: from pa_ind_compiled_sets ics
1889: where ind_compiled_set_id = l_ind_comp_set_id_tab(i)
1890: ;
1891: end if;
1892: end loop;