APPS.GMD_OPTIMIZE_FETCH_PKG dependencies on GMD_TECHNICAL_PARAMETER_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 116: FROM gmd_optimizer_prm_gtmp a, gmd_technical_parameter_gtmp b

112: V_orgn_id IN NUMBER,
113: X_return_status OUT NOCOPY VARCHAR2) IS
114: CURSOR Cur_get_prod IS
115: SELECT a.tech_parm_name,a.lm_unit_code,a.tech_parm_id,b.data_type
116: FROM gmd_optimizer_prm_gtmp a, gmd_technical_parameter_gtmp b
117: WHERE a.entity_id = V_entity_id
118: AND a.entity_id = b.entity_id
119: AND a.tech_parm_id = b.tech_parm_id;
120: BEGIN