APPS.GMD_QMSED dependencies on GMD_SAMPLING_PLANS_B

Line 245: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b

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

Line 313: from gmd_sampling_plans_b a, gmd_sampling_plans_tl b

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