APPS.GMD_PROC_PARAMS_MIGR dependencies on GME_BATCH_STEP_RESOURCES

Line 20: FROM GME_BATCH_STEP_RESOURCES

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
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);

Line 38: FROM GME_BATCH_STEP_RESOURCES

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
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);

Line 56: FROM GME_BATCH_STEP_RESOURCES

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
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);

Line 74: FROM GME_BATCH_STEP_RESOURCES

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
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);

Line 92: FROM GME_BATCH_STEP_RESOURCES

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
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);

Line 778: FROM gme_batch_step_resources;

774: CURSOR Cur_batch_parameters IS
775: SELECT Process_parameter_1,Process_parameter_2,Process_parameter_3,
776: Process_parameter_4,Process_parameter_5,batch_id,batchstep_id,
777: batchstep_activity_id,resources,batchstep_resource_id
778: FROM gme_batch_step_resources;
779: BEGIN
780: FOR l_rec IN Cur_batch_parameters LOOP
781: /* Insert process parameter 1 value into GME_PROCESS_PARAMETERS table */
782: IF l_rec.process_parameter_1 IS NOT NULL THEN