708: PARAMETERS : Category_set_id NUMBER
709: structure_id NUMBER
710:
711: ALGORITHM : Retreive category_set_id and structure_id from
712: mtl_default_sets_view for functional_area_id = 2
713:
714: NOTES :
715:
716: =========================================================================== */
722: SELECT mdsv.category_set_id,
723: mdsv.structure_id
724: INTO x_category_set_id,
725: x_structure_id
726: FROM mtl_default_sets_view mdsv
727: WHERE mdsv.functional_area_id = 2;
728:
729: EXCEPTION
730: WHEN OTHERS THEN