APPS.GMD_STABILITY_STUDIES_GRP dependencies on GMD_SPECIFICATIONS

Line 344: FROM gmd_ss_variants a,gmd_specifications b

340: where material_source_id = source_id ) ;
341:
342: CURSOR cr_variants_storage_spec IS
343: SELECT a.storage_spec_id,b.spec_name,b.spec_vers
344: FROM gmd_ss_variants a,gmd_specifications b
345: WHERE a.ss_id = p_ss_id
346: and a.storage_spec_id = b.spec_id
347: and b.spec_status not in (400,700) ;
348: