APPS.GMD_RECIPE_FETCH_PUB dependencies on GMP_PROCESS_PARAMETERS

Line 1653: FROM gmp_resource_parameters r, gmp_process_parameters p

1649: CURSOR Cur_get_gen_rsrc (V_resources VARCHAR2) IS
1650: SELECT p.parameter_id, parameter_name, parameter_description,
1651: units, r.target_value, r.minimum_value, r.maximum_value,p.parameter_type,r.sequence_no,
1652: r.created_by, r.creation_date, r.last_updated_by, r.last_update_date, r.last_update_login
1653: FROM gmp_resource_parameters r, gmp_process_parameters p
1654: WHERE p.parameter_id = r.parameter_id
1655: AND r.resources = V_resources
1656: ORDER BY r.sequence_no;
1657:

Line 1821: FROM gmp_process_parameters_tl

1817: --===================================================================== */
1818: PROCEDURE get_proc_param_desc(p_parameter_id IN NUMBER, x_parameter_desc OUT NOCOPY VARCHAR2) IS
1819: CURSOR get_proc_param_desc IS
1820: SELECT parameter_description
1821: FROM gmp_process_parameters_tl
1822: WHERE parameter_id = p_parameter_id
1823: AND language = USERENV('LANG');
1824: BEGIN
1825: OPEN get_proc_param_desc;

Line 1847: FROM gmp_process_parameters_b

1843: --===================================================================== */
1844: PROCEDURE get_proc_param_units(p_parameter_id IN NUMBER, x_units OUT NOCOPY VARCHAR2) IS
1845: CURSOR get_proc_param_units IS
1846: SELECT units
1847: FROM gmp_process_parameters_b
1848: WHERE parameter_id = p_parameter_id;
1849: BEGIN
1850: OPEN get_proc_param_units;
1851: FETCH get_proc_param_units INTO x_units;