APPS.GMD_PROC_PARAMS_MIGR dependencies on GMP_PROCESS_PARAMETERS_B

Line 23: FROM GMP_PROCESS_PARAMETERS_B

19: SELECT 1
20: FROM GME_BATCH_STEP_RESOURCES
21: WHERE process_parameter_1 IS NOT NULL)
22: AND NOT EXISTS (SELECT 1
23: FROM GMP_PROCESS_PARAMETERS_B
24: WHERE parameter_id = 1);
25:
26: CURSOR Cur_check_param2 IS
27: SELECT 1

Line 41: FROM GMP_PROCESS_PARAMETERS_B

37: SELECT 1
38: FROM GME_BATCH_STEP_RESOURCES
39: WHERE process_parameter_2 IS NOT NULL)
40: AND NOT EXISTS (SELECT 1
41: FROM GMP_PROCESS_PARAMETERS_B
42: WHERE parameter_id = 2);
43:
44: CURSOR Cur_check_param3 IS
45: SELECT 1

Line 59: FROM GMP_PROCESS_PARAMETERS_B

55: SELECT 1
56: FROM GME_BATCH_STEP_RESOURCES
57: WHERE process_parameter_3 IS NOT NULL)
58: AND NOT EXISTS (SELECT 1
59: FROM GMP_PROCESS_PARAMETERS_B
60: WHERE parameter_id = 3);
61:
62: CURSOR Cur_check_param4 IS
63: SELECT 1

Line 77: FROM GMP_PROCESS_PARAMETERS_B

73: SELECT 1
74: FROM GME_BATCH_STEP_RESOURCES
75: WHERE process_parameter_4 IS NOT NULL)
76: AND NOT EXISTS (SELECT 1
77: FROM GMP_PROCESS_PARAMETERS_B
78: WHERE parameter_id = 4);
79:
80: CURSOR Cur_check_param5 IS
81: SELECT 1

Line 95: FROM GMP_PROCESS_PARAMETERS_B

91: SELECT 1
92: FROM GME_BATCH_STEP_RESOURCES
93: WHERE process_parameter_5 IS NOT NULL)
94: AND NOT EXISTS (SELECT 1
95: FROM GMP_PROCESS_PARAMETERS_B
96: WHERE parameter_id = 5);
97:
98: X_temp NUMBER;
99: X_row_id VARCHAR2(100) DEFAULT NULL;