APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_OPERATION_RESOURCES

Line 12: FROM GMD_OPERATION_RESOURCES

8: CURSOR Cur_check_param1 IS
9: SELECT 1
10: FROM sys.dual
11: WHERE EXISTS (SELECT 1
12: FROM GMD_OPERATION_RESOURCES
13: WHERE process_parameter_1 IS NOT NULL
14: UNION
15: SELECT 1
16: FROM GMD_RECIPE_ORGN_RESOURCES

Line 30: FROM GMD_OPERATION_RESOURCES

26: CURSOR Cur_check_param2 IS
27: SELECT 1
28: FROM sys.dual
29: WHERE EXISTS (SELECT 1
30: FROM GMD_OPERATION_RESOURCES
31: WHERE process_parameter_2 IS NOT NULL
32: UNION
33: SELECT 1
34: FROM GMD_RECIPE_ORGN_RESOURCES

Line 48: FROM GMD_OPERATION_RESOURCES

44: CURSOR Cur_check_param3 IS
45: SELECT 1
46: FROM sys.dual
47: WHERE EXISTS (SELECT 1
48: FROM GMD_OPERATION_RESOURCES
49: WHERE process_parameter_3 IS NOT NULL
50: UNION
51: SELECT 1
52: FROM GMD_RECIPE_ORGN_RESOURCES

Line 66: FROM GMD_OPERATION_RESOURCES

62: CURSOR Cur_check_param4 IS
63: SELECT 1
64: FROM sys.dual
65: WHERE EXISTS (SELECT 1
66: FROM GMD_OPERATION_RESOURCES
67: WHERE process_parameter_4 IS NOT NULL
68: UNION
69: SELECT 1
70: FROM GMD_RECIPE_ORGN_RESOURCES

Line 84: FROM GMD_OPERATION_RESOURCES

80: CURSOR Cur_check_param5 IS
81: SELECT 1
82: FROM sys.dual
83: WHERE EXISTS (SELECT 1
84: FROM GMD_OPERATION_RESOURCES
85: WHERE process_parameter_5 IS NOT NULL
86: UNION
87: SELECT 1
88: FROM GMD_RECIPE_ORGN_RESOURCES

Line 388: FROM gmd_operation_resources;

384: PROCEDURE oprn_process_parameter IS
385: CURSOR Cur_oprn_parameters IS
386: SELECT Process_parameter_1,Process_parameter_2,Process_parameter_3,
387: Process_parameter_4,Process_parameter_5,oprn_line_id,resources
388: FROM gmd_operation_resources;
389: BEGIN
390: FOR l_rec IN Cur_oprn_parameters LOOP
391: /* Insert process parameter 1 value into GMD_OPRN_PROCESS_PARAMETERS table */
392: IF l_rec.process_parameter_1 IS NOT NULL THEN