APPS.GMD_QC_ERES_CHANGE_STATUS_PVT dependencies on GMD_STABILITY_SPEC_VRS

Line 147: from GMD_STABILITY_SPEC_VRS

143: where spec_id = p_spec_id
144: and spec_vr_status < p_to_status
145: UNION
146: select spec_vr_id, 'T' spec_type
147: from GMD_STABILITY_SPEC_VRS
148: where spec_id = p_spec_id
149: and spec_vr_status < p_to_status;
150:
151: l_spec_validity_rule_id NUMBER;