APPS.GMD_OPTIMIZE_FETCH_PKG dependencies on GMD_TECHNICAL_DATA_GTMP

Line 24: FROM gmd_technical_parameter_gtmp a, gmd_technical_data_gtmp b

20: l_prod_rec Cur_get_prod%ROWTYPE;
21:
22: CURSOR Cur_get_prod_param(V_line_id NUMBER) IS
23: SELECT a.*,b.value
24: FROM gmd_technical_parameter_gtmp a, gmd_technical_data_gtmp b
25: WHERE a.tech_parm_id = b.tech_parm_id
26: AND a.entity_id = b.entity_id
27: AND b.line_id = V_line_id
28: AND b.entity_id = V_entity_id

Line 41: FROM gmd_technical_data_gtmp a, gmd_optimizer_prm_gtmp b

37: l_ingred_rec Cur_get_ingred%ROWTYPE;
38:
39: CURSOR Cur_get_value(V_line_id NUMBER) IS
40: SELECT a.*
41: FROM gmd_technical_data_gtmp a, gmd_optimizer_prm_gtmp b
42: WHERE a.entity_id = b.entity_id
43: AND a.tech_parm_id = b.tech_parm_id
44: AND a.line_id = V_line_id;
45: l_value_rec Cur_get_value%ROWTYPE;

Line 650: FROM gmd_technical_data_gtmp

646: FUNCTION get_density_value (V_line_id IN NUMBER,
647: V_density_parameter IN VARCHAR2) RETURN NUMBER IS
648: CURSOR Cur_density IS
649: SELECT value
650: FROM gmd_technical_data_gtmp
651: WHERE line_id = V_line_id
652: AND tech_parm_name = V_density_parameter;
653: l_value NUMBER;
654: BEGIN