APPS.GME_PROCESS_PARAMETERS_PVT dependencies on GMP_PROCESS_PARAMETERS

Line 41: FROM gmp_process_parameters

37: CURSOR cur_process_parameter (v_parameter VARCHAR2)
38: IS
39: SELECT parameter_id, parameter_type, minimum_value, maximum_value
40: ,units
41: FROM gmp_process_parameters
42: WHERE parameter_name = v_parameter AND delete_mark = 0;
43:
44: CURSOR cur_process_value (v_parameter_id NUMBER, v_value VARCHAR2)
45: IS

Line 391: FROM gmp_process_parameters

387:
388: CURSOR cur_process_parameter (v_parameter_id NUMBER)
389: IS
390: SELECT parameter_type
391: FROM gmp_process_parameters
392: WHERE parameter_id = v_parameter_id AND delete_mark = 0;
393:
394: CURSOR cur_process_value (v_parameter_id NUMBER)
395: IS

Line 885: FROM gmp_process_parameters

881:
882: CURSOR cur_check_parameter (v_parameter VARCHAR2)
883: IS
884: SELECT parameter_id
885: FROM gmp_process_parameters
886: WHERE parameter_name = v_parameter AND delete_mark = 0;
887:
888: CURSOR cur_get_parameter (v_resource_id NUMBER, v_parameter VARCHAR2)
889: IS

Line 891: FROM gme_process_parameters p, gmp_process_parameters l

887:
888: CURSOR cur_get_parameter (v_resource_id NUMBER, v_parameter VARCHAR2)
889: IS
890: SELECT process_param_id
891: FROM gme_process_parameters p, gmp_process_parameters l
892: WHERE p.parameter_id = l.parameter_id
893: AND p.batchstep_resource_id = v_resource_id
894: AND l.parameter_name = v_parameter
895: AND l.delete_mark = 0;