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 1691: -- from pa_ind_compiled_sets ics,

1687: -- x_err_stage := 'Delete compiled multiplier for task '|| x_task_id;
1688: -- delete from pa_compiled_multipliers
1689: -- where ind_compiled_set_id in
1690: -- (select ics.ind_compiled_set_id
1691: -- from pa_ind_compiled_sets ics,
1692: -- pa_ind_rate_sch_revisions rev,
1693: -- pa_ind_rate_schedules sch
1694: -- where ics.ind_rate_sch_revision_id =
1695: -- rev.ind_rate_sch_revision_id

Line 1707: -- delete from pa_ind_compiled_sets

1703: -- anlee
1704: -- Commenting out for performance bug 2800129
1705: -- Delete compiled compiled set
1706: -- x_err_stage := 'Delete compiled sets for task '|| x_task_id;
1707: -- delete from pa_ind_compiled_sets
1708: -- where ind_rate_sch_revision_id in
1709: -- (select rev.ind_rate_sch_revision_id
1710: -- from pa_ind_rate_sch_revisions rev,
1711: -- pa_ind_rate_schedules sch

Line 1774: from pa_ind_compiled_sets ics

1770: ;
1771: cursor ics_cur ( l_ind_rate_sch_revision_id IN pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE )
1772: is
1773: select ics.ind_compiled_set_id
1774: from pa_ind_compiled_sets ics
1775: where ics.ind_rate_sch_revision_id = l_ind_rate_sch_revision_id
1776: ;
1777: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1778: l_ind_rate_sch_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1872: from pa_ind_compiled_sets ics

1868: where ind_compiled_set_id = l_ind_comp_set_id_tab(i)
1869: ;
1870: forall i in l_ind_comp_set_id_tab.first .. l_ind_comp_set_id_tab.last
1871: delete
1872: from pa_ind_compiled_sets ics
1873: where ind_compiled_set_id = l_ind_comp_set_id_tab(i)
1874: ;
1875: end if;
1876: end loop;