APPS.GMD_TEST_INTERVAL_PLANS_GRP dependencies on GMD_TEST_INTERVAL_PLAN_PERIODS

Line 34: FROM gmd_test_interval_plan_periods

30: p_test_interval_plan_id IN NUMBER ) RETURN BOOLEAN IS
31:
32: CURSOR Cur_test_interval_plan_period IS
33: SELECT '1'
34: FROM gmd_test_interval_plan_periods
35: WHERE name = p_period
36: AND test_interval_plan_id = p_test_interval_plan_id ;
37:
38: l_temp VARCHAR2(1);

Line 68: FROM GMD_TEST_INTERVAL_PLAN_PERIODS A

64:
65: CURSOR cr_get_max_simulated_date IS
66: SELECT YEARS_FROM_START , MONTHS_FROM_START ,WEEKS_FROM_START,
67: DAYS_FROM_START , HOURS_FROM_START
68: FROM GMD_TEST_INTERVAL_PLAN_PERIODS A
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

Line 77: l_years_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.years_from_start%TYPE;

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;
78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;
79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;
80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;
81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;

Line 78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;

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;
78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;
79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;
80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;
81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;
82: l_lookup_code VARCHAR2(5);

Line 79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;

75: and lookup_code = l_lookup_code ;
76:
77: l_years_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.years_from_start%TYPE;
78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;
79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;
80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;
81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;
82: l_lookup_code VARCHAR2(5);
83:

Line 80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;

76:
77: l_years_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.years_from_start%TYPE;
78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;
79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;
80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;
81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;
82: l_lookup_code VARCHAR2(5);
83:
84: l_year_desc VARCHAR2(25);

Line 81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;

77: l_years_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.years_from_start%TYPE;
78: l_months_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.months_from_start%TYPE;
79: l_weeks_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.weeks_from_start%TYPE;
80: l_days_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.days_from_start%TYPE;
81: l_hours_from_start GMD_TEST_INTERVAL_PLAN_PERIODS.hours_from_start%TYPE;
82: l_lookup_code VARCHAR2(5);
83:
84: l_year_desc VARCHAR2(25);
85: l_month_desc VARCHAR2(25);