DBA Data[Home] [Help]

APPS.JTF_DSPMGRVALIDATION_GRP dependencies on MTL_CATEGORIES

Line 495: select category_id from mtl_categories where category_id=p_category_id);

491: l_api_name CONSTANT VARCHAR2(40) := 'check_category_exists';
492:
493: CURSOR category_cur( p_category_id IN NUMBER ) IS
494: SELECT 1 from dual where exists (
495: select category_id from mtl_categories where category_id=p_category_id);
496:
497: l_exists NUMBER;
498: l_return_status boolean := false;
499: