APPS.GMD_RECIPE_FETCH_PUB dependencies on GMP_PROCESS_PARAMETERS

Line 1714: FROM gmp_resource_parameters r, gmp_process_parameters p

1710: CURSOR Cur_get_gen_rsrc (V_resources VARCHAR2) IS
1711: SELECT p.parameter_id, parameter_name, parameter_description,
1712: units, r.target_value, r.minimum_value, r.maximum_value,p.parameter_type,r.sequence_no,
1713: r.created_by, r.creation_date, r.last_updated_by, r.last_update_date, r.last_update_login
1714: FROM gmp_resource_parameters r, gmp_process_parameters p
1715: WHERE p.parameter_id = r.parameter_id
1716: AND r.resources = V_resources
1717: ORDER BY r.sequence_no;
1718:

Line 1882: FROM gmp_process_parameters_tl

1878: --===================================================================== */
1879: PROCEDURE get_proc_param_desc(p_parameter_id IN NUMBER, x_parameter_desc OUT NOCOPY VARCHAR2) IS
1880: CURSOR get_proc_param_desc IS
1881: SELECT parameter_description
1882: FROM gmp_process_parameters_tl
1883: WHERE parameter_id = p_parameter_id
1884: AND language = USERENV('LANG');
1885: BEGIN
1886: OPEN get_proc_param_desc;

Line 1908: FROM gmp_process_parameters_b

1904: --===================================================================== */
1905: PROCEDURE get_proc_param_units(p_parameter_id IN NUMBER, x_units OUT NOCOPY VARCHAR2) IS
1906: CURSOR get_proc_param_units IS
1907: SELECT units
1908: FROM gmp_process_parameters_b
1909: WHERE parameter_id = p_parameter_id;
1910: BEGIN
1911: OPEN get_proc_param_units;
1912: FETCH get_proc_param_units INTO x_units;