DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_SIMULATION_SETS

Line 30537: WHERE NOT EXISTS (SELECT 1 FROM msc_simulation_sets mss

30533:
30534: CURSOR c8(p_batch_id NUMBER) IS
30535: SELECT max(rowid)
30536: FROM msc_st_resource_changes msrc
30537: WHERE NOT EXISTS (SELECT 1 FROM msc_simulation_sets mss
30538: WHERE msrc.simulation_set = mss.simulation_set
30539: AND msrc.sr_instance_id = mss.sr_instance_id
30540: AND msrc.organization_id = mss.organization_id)
30541: AND msrc.process_flag = G_VALID