APPS.GMD_PROC_PARAMS_MIGR dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 16: FROM GMD_RECIPE_ORGN_RESOURCES

12: FROM GMD_OPERATION_RESOURCES
13: WHERE process_parameter_1 IS NOT NULL
14: UNION
15: SELECT 1
16: FROM GMD_RECIPE_ORGN_RESOURCES
17: WHERE process_parameter_1 IS NOT NULL
18: UNION
19: SELECT 1
20: FROM GME_BATCH_STEP_RESOURCES

Line 34: FROM GMD_RECIPE_ORGN_RESOURCES

30: FROM GMD_OPERATION_RESOURCES
31: WHERE process_parameter_2 IS NOT NULL
32: UNION
33: SELECT 1
34: FROM GMD_RECIPE_ORGN_RESOURCES
35: WHERE process_parameter_2 IS NOT NULL
36: UNION
37: SELECT 1
38: FROM GME_BATCH_STEP_RESOURCES

Line 52: FROM GMD_RECIPE_ORGN_RESOURCES

48: FROM GMD_OPERATION_RESOURCES
49: WHERE process_parameter_3 IS NOT NULL
50: UNION
51: SELECT 1
52: FROM GMD_RECIPE_ORGN_RESOURCES
53: WHERE process_parameter_3 IS NOT NULL
54: UNION
55: SELECT 1
56: FROM GME_BATCH_STEP_RESOURCES

Line 70: FROM GMD_RECIPE_ORGN_RESOURCES

66: FROM GMD_OPERATION_RESOURCES
67: WHERE process_parameter_4 IS NOT NULL
68: UNION
69: SELECT 1
70: FROM GMD_RECIPE_ORGN_RESOURCES
71: WHERE process_parameter_4 IS NOT NULL
72: UNION
73: SELECT 1
74: FROM GME_BATCH_STEP_RESOURCES

Line 88: FROM GMD_RECIPE_ORGN_RESOURCES

84: FROM GMD_OPERATION_RESOURCES
85: WHERE process_parameter_5 IS NOT NULL
86: UNION
87: SELECT 1
88: FROM GMD_RECIPE_ORGN_RESOURCES
89: WHERE process_parameter_5 IS NOT NULL
90: UNION
91: SELECT 1
92: FROM GME_BATCH_STEP_RESOURCES

Line 556: FROM gmd_recipe_orgn_resources;

552: CURSOR Cur_recipe_parameters IS
553: SELECT Process_parameter_1,Process_parameter_2,Process_parameter_3,
554: Process_parameter_4,Process_parameter_5,oprn_line_id,resources,
555: recipe_id,routingstep_id,orgn_code
556: FROM gmd_recipe_orgn_resources;
557: BEGIN
558: FOR l_rec IN Cur_recipe_parameters LOOP
559: /* Insert process parameter 1 value into GMD_RECIPE_PROCESS_PARAMETERS table */
560: IF l_rec.process_parameter_1 IS NOT NULL THEN