546: AND ruleset_id=p_ruleset_id
547: AND org_id=p_org_id;
548:
549: -- Cursor to get the revenue class id, given the revenue class name
550: CURSOR c_revenue_id_csr (l_name cn_revenue_classes.name%TYPE) IS
551: SELECT revenue_class_id
552: FROM cn_revenue_classes
553: WHERE name = l_name
554: and org_id=p_org_id;
548:
549: -- Cursor to get the revenue class id, given the revenue class name
550: CURSOR c_revenue_id_csr (l_name cn_revenue_classes.name%TYPE) IS
551: SELECT revenue_class_id
552: FROM cn_revenue_classes
553: WHERE name = l_name
554: and org_id=p_org_id;
555:
556: -- cursor to get the liability code id