APPS.MTL_CATEGORY_SETS_PKG dependencies on DUAL

Line 711: -- select sysdate into l_date from dual;

707: WHEN NO_DATA_FOUND THEN
708: l_default_category_id := null;
709: END;
710:
711: -- select sysdate into l_date from dual;
712:
713: MTL_CATEGORY_SETS_PKG.Update_Row(
714: X_CATEGORY_SET_ID => l_cat_set_id,
715: X_CATEGORY_SET_NAME => X_CATEGORY_SET_NAME,

Line 744: select MTL_CATEGORY_SETS_S.nextval into l_cat_set_id from dual;

740: WHERE application_id = 401
741: AND id_flex_code = 'MCAT'
742: AND id_flex_structure_code = X_STRUCTURE_CODE;
743:
744: select MTL_CATEGORY_SETS_S.nextval into l_cat_set_id from dual;
745:
746: -- Get default category id from the category code
747: BEGIN
748: SELECT category_id INTO l_default_category_id