APPS.GMD_TEST_INTERVAL_PLANS_GRP dependencies on GEM_LOOKUPS

Line 73: SELECT meaning FROM GEM_LOOKUPS

69: WHERE TEST_INTERVAL_PLAN_ID = p_test_interval_plan_id
70: ORDER BY SIMULATED_DATE DESC ;
71:
72: CURSOR cr_get_period_unit_desc(l_lookup_code VARCHAR2) IS
73: SELECT meaning FROM GEM_LOOKUPS
74: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
75: and lookup_code = l_lookup_code ;
76:
77: l_years_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.years_from_start%TYPE;