APPS.GMD_SAMPLES_GRP dependencies on GMP_RESOURCE_INSTANCES

Line 5986: GMP_RESOURCE_INSTANCES ri,

5982: v.resources,
5983: ri.instance_number
5984: FROM GMD_SS_VARIANTS v,
5985: GMD_STABILITY_STUDIES_B ss,
5986: GMP_RESOURCE_INSTANCES ri,
5987: MTL_PARAMETERS p
5988: WHERE variant_id = p_variant_id
5989: AND ss.ss_id = v.ss_id
5990: AND ri.instance_id(+) = v.resource_instance_id

Line 6079: FROM GMP_RESOURCE_INSTANCES

6075:
6076: IS
6077: CURSOR Cur_instance IS
6078: SELECT INSTANCE_NUMBER
6079: FROM GMP_RESOURCE_INSTANCES
6080: WHERE instance_id = p_instance_id;
6081: BEGIN
6082: IF (p_instance_id IS NOT NULL) THEN
6083: OPEN Cur_instance;