APPS.OKL_SYP_PVT dependencies on OKL_SYSTEM_PARAMS_ALL_PUB

Line 1374: AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)

1370: SELECT 'X'
1371: FROM MTL_ITEM_CATEGORIES MTLITMCATS,
1372: MTL_CATEGORY_SETS MTLCATSETS
1373: WHERE MTLITMCATS.CATEGORY_SET_ID = MTLCATSETS.CATEGORY_SET_ID
1374: AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
1375: AND MTLCATSETS.MULT_ITEM_CAT_ASSIGN_FLAG = 'N'
1376: AND MTLITMCATS.CATEGORY_SET_ID = cp_cat_set_id;
1377:
1378: l_dummy VARCHAR2(1);