APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_PARAMETERS

Line 304: FROM MTL_PARAMETERS

300: END IF;
301:
302: BEGIN
303: SELECT 'Y' INTO l_org_assignment
304: FROM MTL_PARAMETERS
305: WHERE ORGANIZATION_ID = l_organization_id
306: AND ORGANIZATION_ID <> MASTER_ORGANIZATION_ID;
307: EXCEPTION WHEN NO_DATA_FOUND THEN
308: l_org_assignment := 'N';

Line 794: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

790: ,x_msg_data OUT NOCOPY VARCHAR2)
791: IS
792: l_menu_id NUMBER;
793: l_menu_disp_name FND_MENUS_VL.USER_MENU_NAME%TYPE;
794: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
795: l_object_id NUMBER;
796: l_ss_id NUMBER := EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID;
797: BEGIN
798: BEGIN

Line 809: FROM MTL_PARAMETERS

805: END;
806:
807: BEGIN
808: SELECT ORGANIZATION_CODE INTO l_org_code
809: FROM MTL_PARAMETERS
810: WHERE ORGANIZATION_ID = p_organization_id;
811: EXCEPTION WHEN NO_DATA_FOUND THEN
812: l_org_code := '-X-';
813: END;

Line 850: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

846: l_org_code,
847: l_menu_disp_name,
848: l_ss_id,
849: -99
850: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
851: WHERE msib.STYLE_ITEM_ID = p_style_item_id
852: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
853: AND mp.ORGANIZATION_ID = p_organization_id
854: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg

Line 911: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp

907: p_category_set_id,
908: p_category_id,
909: l_ss_id,
910: -99
911: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
912: WHERE msib.STYLE_ITEM_ID = p_style_item_id
913: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
914: AND mp.ORGANIZATION_ID = p_organization_id
915: AND NOT EXISTS (SELECT NULL FROM MTL_ITEM_CATEGORIES mic