DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMP_RESOURCE_INSTANCES

Line 5318: GMP_RESOURCE_INSTANCES ri,

5314: v.resources,
5315: ri.instance_number
5316: FROM GMD_SS_VARIANTS v,
5317: GMD_STABILITY_STUDIES_B ss,
5318: GMP_RESOURCE_INSTANCES ri,
5319: MTL_PARAMETERS p
5320: WHERE variant_id = p_variant_id
5321: AND ss.ss_id = v.ss_id
5322: AND ri.instance_id(+) = v.resource_instance_id

Line 5411: FROM GMP_RESOURCE_INSTANCES

5407:
5408: IS
5409: CURSOR Cur_instance IS
5410: SELECT INSTANCE_NUMBER
5411: FROM GMP_RESOURCE_INSTANCES
5412: WHERE instance_id = p_instance_id;
5413: BEGIN
5414: IF (p_instance_id IS NOT NULL) THEN
5415: OPEN Cur_instance;