DBA Data[Home] [Help]

APPS.CS_CONTRACTS_PUB dependencies on FND_PROFILE

Line 53: AND organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');

49: p_cp_service_id IN MTL_SYSTEM_ITEMS_KFV.INVENTORY_ITEM_ID%TYPE) IS
50: SELECT concatenated_segments
51: FROM mtl_system_items_kfv
52: WHERE inventory_item_id = p_cp_service_id
53: AND organization_id = FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID');
54:
55: l_retval get_service_name_cur%ROWTYPE;
56: BEGIN
57: OPEN get_service_name_cur (p_services_rec.cp_service_id);