22: /* Check if the given Category is active */
23:
24: SELECT category_id
25: INTO X_category_id_v 26: FROM mtl_categories 27: WHERE sysdate < nvl(disable_date, sysdate + 1)
28: AND enabled_flag = 'Y'
29: AND sysdate between nvl(start_date_active, sysdate -1)
30: AND nvl(end_date_active, sysdate + 1)