DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on GEM_LOOKUPS

Line 382: FROM gem_lookups

378: and sv.spec_vr_id = X_SPEC_VR_ID;
379:
380: CURSOR sample_plan_freq_per (x_frequency_per varchar2 ) is
381: SELECT meaning
382: FROM gem_lookups
383: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
384: and lookup_code = x_frequency_per ;
385:
386:

Line 2026: FROM gem_lookups

2022: AND sv.spec_vr_id = X_SPEC_VR_ID;
2023:
2024: CURSOR wip_sample_plan_freq_per (x_frequency_per varchar2 ) IS
2025: SELECT meaning
2026: FROM gem_lookups
2027: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
2028: AND lookup_code = x_frequency_per ;
2029:
2030: CURSOR get_sampling_plan_id (x_spec_vr_id_in number) IS