[Home] [Help]
1095: transfer_pct, text_code, creation_date, created_by,last_updated_by,
1096: last_update_date, last_update_login,chargeable_ind
1097: --Sriram.S APS K Enhancements 03March2004 Bug# 3410379
1098: --Added chargable_ind column to the select statement
1099: FROM fm_rout_dep
1100: WHERE routing_id = (SELECT routing_id
1101: FROM gmd_recipes_b
1102: WHERE recipe_id = p_recipe_id) ;
1103:
1101: FROM gmd_recipes_b
1102: WHERE recipe_id = p_recipe_id) ;
1103:
1104:
1105: depd_rec fm_rout_dep%rowtype;
1106:
1107: /*** local Variables ***/
1108: l_api_name CONSTANT VARCHAR2(30) := 'get_step_depd_details';
1109: l_api_version CONSTANT NUMBER := 1.0;