Line 66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk
62:
63: /*Cursor to get the common fields in the workflow notification*/
64: CURSOR common_fields IS
65: select mp.organization_code, gse.sample_type, glk.meaning 66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk 67: where gse.sampling_event_id = l_event_key
68: and gse.organization_id = mp.organization_id
69: and glk.lookup_type = 'GMD_QC_SPEC_TYPE'
70: and gse.sample_type = glk.lookup_code;