DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_IND_RATE_SCH_REVISIONS

Line 4857: pa_ind_rate_sch_revisions rev,

4853: DELETE FROM pa_compiled_multipliers
4854: WHERE ind_compiled_set_id IN
4855: (SELECT ics.ind_compiled_set_id
4856: FROM pa_ind_compiled_sets ics,
4857: pa_ind_rate_sch_revisions rev,
4858: pa_ind_rate_schedules sch
4859: WHERE ics.ind_rate_sch_revision_id =
4860: rev.ind_rate_sch_revision_id
4861: AND rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 4867: FROM pa_ind_rate_sch_revisions rev,

4863:
4864: DELETE FROM pa_ind_compiled_sets
4865: WHERE ind_rate_sch_revision_id IN
4866: (SELECT rev.ind_rate_sch_revision_id
4867: FROM pa_ind_rate_sch_revisions rev,
4868: pa_ind_rate_schedules sch
4869: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4870: AND sch.task_id = p_task_id );
4871:

Line 4872: DELETE FROM pa_ind_rate_sch_revisions

4868: pa_ind_rate_schedules sch
4869: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4870: AND sch.task_id = p_task_id );
4871:
4872: DELETE FROM pa_ind_rate_sch_revisions
4873: WHERE ind_rate_sch_id IN
4874: (SELECT ind_rate_sch_id
4875: FROM pa_ind_rate_schedules
4876: WHERE task_id = p_task_id );