[Home] [Help]
144:
145: BEGIN
146: SELECT revenue_class_id
147: INTO l_rev_class_id
148: FROM cn_revenue_classes_all
149: WHERE name = p_rev_class_name
150: AND org_id = p_org_id
151: ;
152: RETURN l_rev_class_id;
166:
167: BEGIN
168: SELECT name
169: INTO l_rev_class_name
170: FROM cn_revenue_classes_all
171: WHERE revenue_class_id = p_rev_class_id
172: ;
173: RETURN l_rev_class_name;
174: EXCEPTION