APPS.GMD_TEST_INTERVAL_PLANS_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

      SELECT '1'
      FROM  gmd_test_interval_plans_b
      WHERE name = p_test_interval_plan_name;

Line: 33

      SELECT '1'
      FROM  gmd_test_interval_plan_periods
      WHERE name = p_period
      AND   test_interval_plan_id = p_test_interval_plan_id ;

Line: 66

SELECT  YEARS_FROM_START ,   MONTHS_FROM_START      ,WEEKS_FROM_START,
	DAYS_FROM_START  ,   HOURS_FROM_START
FROM    GMD_TEST_INTERVAL_PLAN_PERIODS A
WHERE   TEST_INTERVAL_PLAN_ID = p_test_interval_plan_id
ORDER BY SIMULATED_DATE DESC ;

Line: 73

SELECT meaning FROM GEM_LOOKUPS
WHERE  lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
and    lookup_code = l_lookup_code ;

Line: 144

      SELECT DECODE(l_years_from_start,NULL,NULL,l_years_from_start||' '||l_year_desc||' ')||
      		DECODE(l_months_from_start,NULL,NULL,l_months_from_start||' '||l_month_desc||' ')||
      		DECODE(l_weeks_from_start,NULL,NULL,l_weeks_from_start||' '||l_week_desc||' ')||
      		DECODE(l_days_from_start,NULL,NULL,l_days_from_start||' '||l_day_desc||' ')||
      		DECODE(l_hours_from_start,NULL,NULL,l_hours_from_start||' '||l_hour_desc)
      INTO l_string FROM DUAL ;