APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_TECH_PARAMETERS_B

Line 1632: FROM gmd_tech_parameters_b

1628: P_entity_id NUMBER) IS
1629:
1630: CURSOR cur_get_param (v_density VARCHAR2) IS
1631: SELECT tech_parm_id
1632: FROM gmd_tech_parameters_b
1633: WHERE tech_parm_name = v_density
1634: AND organization_id = P_orgn_id;
1635:
1636: CURSOR cur_get_value (v_tech_parm_id NUMBER) IS

Line 1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c

1820:
1821: PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER) IS
1822: CURSOR Cur_get_type IS
1823: SELECT a.*, c.line_id line, b.tech_parm_id tech, b.tech_parm_name name,b.sort_seq, c.inventory_item_id
1824: FROM gmd_tech_parameters_b a, gmd_technical_parameter_gtmp b, gmd_material_details_gtmp c
1825: WHERE a.tech_parm_id = b.tech_parm_id
1826: AND c.line_id = V_line_id;
1827: l_value NUMBER;
1828: l_parm_value VARCHAR2(240);