DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_IND_RATE_SCH_REVISIONS

Line 4660: pa_ind_rate_sch_revisions rev,

4656: DELETE FROM pa_compiled_multipliers
4657: WHERE ind_compiled_set_id IN
4658: (SELECT ics.ind_compiled_set_id
4659: FROM pa_ind_compiled_sets ics,
4660: pa_ind_rate_sch_revisions rev,
4661: pa_ind_rate_schedules sch
4662: WHERE ics.ind_rate_sch_revision_id =
4663: rev.ind_rate_sch_revision_id
4664: AND rev.ind_rate_sch_id = sch.ind_rate_sch_id

Line 4670: FROM pa_ind_rate_sch_revisions rev,

4666:
4667: DELETE FROM pa_ind_compiled_sets
4668: WHERE ind_rate_sch_revision_id IN
4669: (SELECT rev.ind_rate_sch_revision_id
4670: FROM pa_ind_rate_sch_revisions rev,
4671: pa_ind_rate_schedules sch
4672: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4673: AND sch.task_id = p_task_id );
4674:

Line 4675: DELETE FROM pa_ind_rate_sch_revisions

4671: pa_ind_rate_schedules sch
4672: WHERE rev.ind_rate_sch_id = sch.ind_rate_sch_id
4673: AND sch.task_id = p_task_id );
4674:
4675: DELETE FROM pa_ind_rate_sch_revisions
4676: WHERE ind_rate_sch_id IN
4677: (SELECT ind_rate_sch_id
4678: FROM pa_ind_rate_schedules
4679: WHERE task_id = p_task_id );