APPS.GMD_RESULTS_GRP dependencies on GEM_LOOKUPS

Line 371: FROM gem_lookups

367: -- or Reject then you can not add sample anymore.
368: IF (l_sampling_event.disposition IN ('4A', '5AV', '6RJ')) THEN
369: SELECT meaning
370: INTO l_meaning
371: FROM gem_lookups
372: WHERE lookup_type = 'GMD_QC_SAMPLE_DISP'
373: AND lookup_code = l_sampling_event.disposition;
374:
375: GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_DISPOSED',

Line 1514: FROM gem_lookups

1510: -- IF (l_sampling_event.disposition IN ('4A', '5AV', '6RJ')) THEN
1511: IF (l_sample_spec_disp IN ('4A', '5AV', '6RJ')) THEN -- 3903309
1512: SELECT meaning
1513: INTO l_meaning
1514: FROM gem_lookups
1515: WHERE lookup_type = 'GMD_QC_SAMPLE_DISP'
1516: AND lookup_code = l_sample_spec_disp; -- 3903309
1517:
1518: GMD_API_PUB.Log_Message('GMD_CANT_ADD_TEST');