101: END get_ledger_name;
102:
103: --get Cost type name
104: FUNCTION get_cost_type(p_ct_id IN NUMBER) RETURN VARCHAR2 IS
105: l_cost_type cm_mthd_mst.cost_mthd_code%TYPE :='';
106: BEGIN
107: SELECT cost_mthd_code INTO l_cost_type FROM cm_mthd_mst
108: WHERE cost_type_id = p_ct_id;
109:
103: --get Cost type name
104: FUNCTION get_cost_type(p_ct_id IN NUMBER) RETURN VARCHAR2 IS
105: l_cost_type cm_mthd_mst.cost_mthd_code%TYPE :='';
106: BEGIN
107: SELECT cost_mthd_code INTO l_cost_type FROM cm_mthd_mst
108: WHERE cost_type_id = p_ct_id;
109:
110: RETURN l_cost_type;
111: