APPS.GMD_RESULTS_GRP dependencies on GEM_LOOKUPS

Line 323: FROM gem_lookups

319: -- or Reject then you can not add sample anymore.
320: IF (l_sampling_event.disposition IN ('4A', '5AV', '6RJ')) THEN
321: SELECT meaning
322: INTO l_meaning
323: FROM gem_lookups
324: WHERE lookup_type = 'GMD_QC_SAMPLE_DISP'
325: AND lookup_code = l_sampling_event.disposition;
326:
327: GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_DISPOSED',

Line 1438: FROM gem_lookups

1434: -- IF (l_sampling_event.disposition IN ('4A', '5AV', '6RJ')) THEN
1435: IF (l_sample_spec_disp IN ('4A', '5AV', '6RJ')) THEN -- 3903309
1436: SELECT meaning
1437: INTO l_meaning
1438: FROM gem_lookups
1439: WHERE lookup_type = 'GMD_QC_SAMPLE_DISP'
1440: AND lookup_code = l_sample_spec_disp; -- 3903309
1441:
1442: GMD_API_PUB.Log_Message('GMD_CANT_ADD_TEST');