APPS.GMD_FETCH_OPRN dependencies on GMD_OPRN_PROCESS_PARAMETERS_V1

Line 420: FROM gmd_oprn_process_parameters_v1 p, gmp_process_parameters g

416:
417: /* Parameters at the oprn resource level */
418: CURSOR Cur_get_oprn_rsrc IS
419: SELECT p.*,g.parameter_name,g.parameter_description,g.units,g.parameter_type
420: FROM gmd_oprn_process_parameters_v1 p, gmp_process_parameters g
421: WHERE p.oprn_line_id = P_oprn_line_id
422: AND p.resources = P_resources
423: AND p.parameter_id = g.parameter_id
424: ORDER BY sequence_no;