APPS.GMD_QMSED dependencies on GMD_SAMPLING_PLANS_B

Line 247: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b

243:
244: IF l_sampling_plan_id IS NOT NULL THEN
245: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
246: into l_sample_plan
247: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b
248: where a.sampling_plan_id = b.sampling_plan_id
249: and a.sampling_plan_id = l_sampling_plan_id
250: and b.language = userenv('LANG');
251: END IF;

Line 315: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b

311:
312: IF l_sampling_plan_id IS NOT NULL THEN
313: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
314: into l_sample_plan
315: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b
316: where a.sampling_plan_id = b.sampling_plan_id
317: and a.sampling_plan_id = l_sampling_plan_id
318: and b.language = userenv('LANG');
319: END IF;